|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 23rd, 2008, 11:39 AM
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
September 23rd, 2008, 11:51 AM
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
September 23rd, 2008, 12:29 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
