Sorry to go off topic, but do you have any ideas about what formula I could use to search my worksheet for a list of public holidays. I also need it to highlight the matches. Any ideas?
In regards to the compact layout, you don't have to use the drop down that Bill mentions. If you just choose the tier that you want to filter, just right click and select your filter type there. Also, the filter button in the heading row will automatically correspond to the tier that is selected by the active cell. The compact layout makes VLOOKUPs against a pivot incredibly easy, too. Keep up the good work guys, I've learned a lot over the years from your contributions.
Hey Bill. Nice job of you both. I'm a subscriber. Anyway. Have you got Polish roots? Jelen in Polish means "deer". It's definitely Polish surname. Greetings.
Be careful with "Mike's cool method", the IF method would calculate faster for huge spreadsheets!!!! The COUNTIF with expandable range will have formulas at the bottom of the column that has to look through a lot more cells and thus takes longer to calculate. Bill Mr Excel Jelen always closes the video, if I would have closed the video I would have given Mr Excel the point becasue the PT was better and his IF was better!!
Sorry to go off topic, but do you have any ideas about what formula I could use to search my worksheet for a list of public holidays. I also need it to highlight the matches. Any ideas?
lorrainecfernandez 9 months ago
Post question to THE best Excel question site:
mrexcel[dot]com/forum
ExcelIsFun 9 months ago
if i am not wromg both the results will be different.
Mr.Excel you are doing a sum per customer then sort while Mike you do not sum... guess top two is mis leading here .
JPdotS 10 months ago
I did not think there were any duplicates, so I do not think that the PT way will give inconsistent answers.
ExcelIsFun 10 months ago
Nice vidoe as always. Mike your solution is not working in Exel 2003 since we can filter one value at a time.
planiolro 10 months ago
In regards to the compact layout, you don't have to use the drop down that Bill mentions. If you just choose the tier that you want to filter, just right click and select your filter type there. Also, the filter button in the heading row will automatically correspond to the tier that is selected by the active cell. The compact layout makes VLOOKUPs against a pivot incredibly easy, too. Keep up the good work guys, I've learned a lot over the years from your contributions.
ChrisJessWatts 10 months ago
Thanks for the hot tip!!!
I am glad that you like the videos over the years!
ExcelIsFun 10 months ago
Hey Bill. Nice job of you both. I'm a subscriber. Anyway. Have you got Polish roots? Jelen in Polish means "deer". It's definitely Polish surname. Greetings.
MrRostkovsky 10 months ago
Bill Mr Excel Jelen is bjele123 at YouTube. You may have to post your question to him.
Thanks for watching!
--excelisfun
ExcelIsFun 10 months ago
Excellent as usual, guys - both methods are equally good.
However, in industry - pivot tables are utilized more i think than the spreadsheet method. Too bad.
Bill - for the extra column method - that is how i do it. I have to start using Mike's method more - becuase it looks cooler.
pwrsrg7777 10 months ago
Be careful with "Mike's cool method", the IF method would calculate faster for huge spreadsheets!!!! The COUNTIF with expandable range will have formulas at the bottom of the column that has to look through a lot more cells and thus takes longer to calculate. Bill Mr Excel Jelen always closes the video, if I would have closed the video I would have given Mr Excel the point becasue the PT was better and his IF was better!!
ExcelIsFun 10 months ago
Great!!!
loyaus 10 months ago
I am glad that you liked it!!!
ExcelIsFun 10 months ago
bill has glasses!
iamipula 10 months ago
WOO, you are right!!! Before - no glasses, After - yes glasses!!!
ExcelIsFun 10 months ago