Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup and if, I think
I have the following data:
Client January February March (and so on until December) A 1 1 1 1 1 1 1 1 B 1 1 1 1 1 1 Each time I visit a client, I enter a 1 in the corresponding cell. I want to detail, in a separate range, how many times I visit a client in each month. Trying to clarify a bit mo I want to have a list in a cell with the clients, a list in another cell with the months, and when I choose for example A, February, to obtain a 3. Is this possible? Thanks in advance, Regards, Emece.- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup and if, I think
Assuming your data A1:M3
Criteria A10: A, B10: February =LEN(SUBSTITUTE(INDEX(A1:M3,MATCH(A10,A1:A3,0),MAT CH(B10,A1:M1,0))," ",)) "Emece" wrote: I have the following data: Client January February March (and so on until December) A 1 1 1 1 1 1 1 1 B 1 1 1 1 1 1 Each time I visit a client, I enter a 1 in the corresponding cell. I want to detail, in a separate range, how many times I visit a client in each month. Trying to clarify a bit mo I want to have a list in a cell with the clients, a list in another cell with the months, and when I choose for example A, February, to obtain a 3. Is this possible? Thanks in advance, Regards, Emece.- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup and if, I think
Thank you very much for your help. I am sure it is the right answer altough
it didn't work in all cases. I think this is because I have merged cells in the sheet, so in some cases I get the error #REF! For example I have January merged from cells E1 to J1, and below six cells where I enter a 1 for each visit to the client. I don't want to bother you, but is there a possibility for me to send you the worksheet so you can see it? I really need this to work properly. Thanks in advance. Regards, Emece.- "Teethless mama" wrote: Assuming your data A1:M3 Criteria A10: A, B10: February =LEN(SUBSTITUTE(INDEX(A1:M3,MATCH(A10,A1:A3,0),MAT CH(B10,A1:M1,0))," ",)) "Emece" wrote: I have the following data: Client January February March (and so on until December) A 1 1 1 1 1 1 1 1 B 1 1 1 1 1 1 Each time I visit a client, I enter a 1 in the corresponding cell. I want to detail, in a separate range, how many times I visit a client in each month. Trying to clarify a bit mo I want to have a list in a cell with the clients, a list in another cell with the months, and when I choose for example A, February, to obtain a 3. Is this possible? Thanks in advance, Regards, Emece.- |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup and if, I think
Thanks for your answer. I am sure that is the correct function, although it
doesn't work correctly in all cases. I think this is because I have merged cells in the worksheet. I don't want to bother you too much, but can I possibly send you the worksheet so you can check this? I really need this to work properly. Thanks in advance. Regards, Emece.- "Emece" wrote: I have the following data: Client January February March (and so on until December) A 1 1 1 1 1 1 1 1 B 1 1 1 1 1 1 Each time I visit a client, I enter a 1 in the corresponding cell. I want to detail, in a separate range, how many times I visit a client in each month. Trying to clarify a bit mo I want to have a list in a cell with the clients, a list in another cell with the months, and when I choose for example A, February, to obtain a 3. Is this possible? Thanks in advance, Regards, Emece.- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |