Sort by time | Sort by thread (beta)
Link to this comment:
Share to:
Loading...
- Your queue is empty. Add videos to your queue using this button:
or sign in to load a different list.
Loading...Saving...
Aladin? Just rub the magic lamp and bum!
This is a fantastic formula.
chinchonchinchon 1 year ago
EMT 478 and 479 are much better than this one. You should watch those.
ExcelIsFun 1 year ago
@ExcelIsFun
Perhaps in the future the Excel people are going to create a formula or formulas to solve these kind of problems, instead of using small, if as in this one.
chinchonchinchon 1 year ago
That would be cool!
ExcelIsFun 1 year ago
@ExcelIsFun
I meant functions, not formulas.
chinchonchinchon 1 year ago
this guy is toooo much.... the formula is like a whole paragraph.
tbaiyewu 1 year ago
this is nutz - fair play
Jakers2009 2 years ago
That formula is fucked. Damn you are good.
gredangeo 2 years ago
Dear gredangeo,
I hope that means you found some use with the formula.
If you have duplicates, see this video for a formula that will work:
Excel Magic Trick #149: Reverse 2-Way Lookup No Duplicates
--excelisfun
ExcelIsFun 2 years ago
im revisiting this video,ehe
its an arraty formula because of the column array ryt?
tnx
soulsaver04 2 years ago
Dear soulsaver04 ,
The array comes from a few parts in the formula: The COLUMN and the SMALL(IF
Be sure to watch this video that shows a better formula for when you have duplicates:
Excel Magic Trick #149: Reverse 2-Way Lookup No Duplicates
--excelisfun
ExcelIsFun 2 years ago
haha! luckily theres a rewind button! c0ol stuff!
god bless exceisfun and alladin
soulsaver04 2 years ago
Dear soulsaver04,
I am glad that it was helpful! Aladin helped both of us!
Important note: If you have duplicates inside the table be sure to watch this for a more robust formula:
Excel Magic Trick #149.5: Reverse 2-Way Lookup w Duplicates
--excelisfun
ExcelIsFun 2 years ago