I am trying to list the latest date, B7:B11, using the product class as criteria and a table of data which list various product class's multiple times.
Thank you for any help.
I am trying to list the latest date, B7:B11, using the product class as criteria and a table of data which list various product class's multiple times.
Thank you for any help.
What are your expected results?
BSB
Your expected results are missing from your workbook. You had this working in the workbook in your previous thread - why are you trying to reinvent the wheel?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I'm trying to do this example because I receive numerous files from people who use different methods for different reasons. The helper columns I added were just an example in one of my personal files. I then relized I would have to add helper columns in all the other files I get every time I get a file from someone. I'm trying to do this using something that is common amongst all of the files which is product class.
->BadlySpelledBouy, my expected results would in the updated attachment.
Are you still using 2007?
B7=IF($A7<>"",MAX(IF($D$7:$D$21=$A7,IF($E$7:$AQ$21>0,IF($E$6:$AQ$6>4000,$E$6:$AQ$6)))),"")
Control+shift+enter
copy down
Thanks Caracalla, your formula worked great!
Just for anyone who is interested, here's a PowerQuery solution (for later versions of Excel with access to the add-in).
M Code:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks