Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
max date based on criteria
it is not working
the data values are as follows A B C D = = = = AAA 01-Sep-08 AAA 5-Sep-08 BBB 02-Sep-08 BBB 5-Sep-08 CCC 03-Sep-08 AAA 04-Sep-08 AAA 05-Sep-08 BBB 03-Sep-08 here d column has the formula as follows =MAX(IF(A$1:A$10=C3,B$1:B$10,FALSE)) but all the values are showing max of column D. i need max of AAA or max of BBB how to do this output should be as follows A B C D = = = = AAA 01-Sep-08 AAA 5-Sep-08 BBB 02-Sep-08 BBB 3-Sep-08 CCC 03-Sep-08 AAA 04-Sep-08 AAA 05-Sep-08 BBB 03-Sep-08 here BBB is 3 sep what is the formula i have to use , help me Regards Ramkumar |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
max date based on criteria
Please don't start another thread. you have further responses in the original
"ramudt" wrote: it is not working the data values are as follows A B C D = = = = AAA 01-Sep-08 AAA 5-Sep-08 BBB 02-Sep-08 BBB 5-Sep-08 CCC 03-Sep-08 AAA 04-Sep-08 AAA 05-Sep-08 BBB 03-Sep-08 here d column has the formula as follows =MAX(IF(A$1:A$10=C3,B$1:B$10,FALSE)) but all the values are showing max of column D. i need max of AAA or max of BBB how to do this output should be as follows A B C D = = = = AAA 01-Sep-08 AAA 5-Sep-08 BBB 02-Sep-08 BBB 3-Sep-08 CCC 03-Sep-08 AAA 04-Sep-08 AAA 05-Sep-08 BBB 03-Sep-08 here BBB is 3 sep what is the formula i have to use , help me Regards Ramkumar |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
max date based on criteria
sorry
"Mike H" wrote: Please don't start another thread. you have further responses in the original "ramudt" wrote: it is not working the data values are as follows A B C D = = = = AAA 01-Sep-08 AAA 5-Sep-08 BBB 02-Sep-08 BBB 5-Sep-08 CCC 03-Sep-08 AAA 04-Sep-08 AAA 05-Sep-08 BBB 03-Sep-08 here d column has the formula as follows =MAX(IF(A$1:A$10=C3,B$1:B$10,FALSE)) but all the values are showing max of column D. i need max of AAA or max of BBB how to do this output should be as follows A B C D = = = = AAA 01-Sep-08 AAA 5-Sep-08 BBB 02-Sep-08 BBB 3-Sep-08 CCC 03-Sep-08 AAA 04-Sep-08 AAA 05-Sep-08 BBB 03-Sep-08 here BBB is 3 sep what is the formula i have to use , help me Regards Ramkumar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select criteria based on date | Excel Discussion (Misc queries) | |||
count based on 2 criteria (date and status) | Excel Discussion (Misc queries) | |||
Result Based on Date Criteria | Excel Discussion (Misc queries) | |||
Calculate average based on date and other criteria | Excel Discussion (Misc queries) | |||
count based on multiple date criteria | Excel Worksheet Functions |