Also, sometimes you can achieve what you need by ordering the results based on the field that is being filtered and then just copying the range.
https://twitter.com/TrungTPhan/status/1734985280732680515?t=j_u0Dfyq8lm2iQ7mPvpRYQ&s=19
Andrew āThe Annihilatorā 
3 Likes
Is there a Junior B Excel Championship? I reckon I could hold my own there but no way could I commit to Senior atm.
1 Like
Any excel formulas for the below example
Iād be looking for it to output
A Version 1
B Version 2
C Version 1, 3, 5
Duplicate the second column and you can get a pivot table by name with version across horizontal that shows on screen what you need.
Should be able to lookup and concatenate from there, excluding blanks.
The tech hates me, anything that can go wrong etc.
Anyhow- is there a reason why a certificate of motor insurance wont print properly- i open the pdf, jab printā¦ the proforma cert prints ok, but without reg, name, date of expiry etc
Switch off the smuggling/counterfeiting settings?
1 Like
Have you an ink colour problem?
Donāt seem to have
Youāre a gent
1 Like
Where is it?
All the usual sites like Etsy, Amazon and eBay.
1 Like
Holy Moses 
Very basic issue here, but if someone who uses sheets can help me:
Want the percentage to come out as 98.33%, but something is fucked with the formula.
Divide by 100?
2 Likes
Tried that, didnāt work for some reason. Think I need to add some brackets, dunno where.
Everywhere
(what you had) /100
2 Likes
Cheers, will try.