| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
returning a value from a specific row to another specific row
i really need help on this one. i don't know if it's possible but i still
want to try. here's the case: A B row8 01- May F row9 01-May D row10 01-May F row11 01-May F row12 02-May F in this case, i want to return how many "F" on 01-May only. i hope there's a specific formula for this one. it's a really big help if there is...thanks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
returning a value from a specific row to another specific row
enter this in C9
=SUMPRODUCT(--($A$8:$A$12=A8),--($B$8:$B$12=B8)) and copy down... It will give you the count for the combination of values in Col A and B in that row. You can also list unique combinations in another place and use that reference in place of A8 and B8. "kyoko" wrote: i really need help on this one. i don't know if it's possible but i still want to try. here's the case: A B row8 01- May F row9 01-May D row10 01-May F row11 01-May F row12 02-May F in this case, i want to return how many "F" on 01-May only. i hope there's a specific formula for this one. it's a really big help if there is...thanks in advance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
returning a value from a specific row to another specific row
=SUMPRODUCT(--(TEXT(A1:A100,"ddmm")="0105"),--(B1:B100="F"))
-- If this post helps click Yes --------------- Jacob Skaria "kyoko" wrote: i really need help on this one. i don't know if it's possible but i still want to try. here's the case: A B row8 01- May F row9 01-May D row10 01-May F row11 01-May F row12 02-May F in this case, i want to return how many "F" on 01-May only. i hope there's a specific formula for this one. it's a really big help if there is...thanks in advance. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
returning a value from a specific row to another specific row
hey, thanks a lot! it works!!
"Sheeloo" wrote: enter this in C9 =SUMPRODUCT(--($A$8:$A$12=A8),--($B$8:$B$12=B8)) and copy down... It will give you the count for the combination of values in Col A and B in that row. You can also list unique combinations in another place and use that reference in place of A8 and B8. "kyoko" wrote: i really need help on this one. i don't know if it's possible but i still want to try. here's the case: A B row8 01- May F row9 01-May D row10 01-May F row11 01-May F row12 02-May F in this case, i want to return how many "F" on 01-May only. i hope there's a specific formula for this one. it's a really big help if there is...thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| returning a specific cell value | Excel Discussion (Misc queries) | |||
| RETURNING A SPECIFIC VALUE FROM A LOOKUP FORMULA | Excel Discussion (Misc queries) | |||
| returning specific text only | Excel Worksheet Functions | |||
| Returning Specific Cell Content using IF Statement | Excel Discussion (Misc queries) | |||
| Returning specific cell if zero | Excel Worksheet Functions | |||
Linear Mode
