Count formula problem
I have 6 fields numbered 1 thru 6, I want each to look for its own number in
a column even if there are multiple numbers in it... A1 to look through F1 thru F2999 which can contain any combination of numbers1 thru 6. Say F32 has the numbers 1, 3, 5, can a formula recognize each of those numbers? |
Count formula problem
What do you want to do? Count the number of times 1, 2, etc appear in
F1:F2999? Enter =COUNTIF(F1:F2999,"1") etc. -- Brevity is the soul of wit. "Major Tomm" wrote: I have 6 fields numbered 1 thru 6, I want each to look for its own number in a column even if there are multiple numbers in it... A1 to look through F1 thru F2999 which can contain any combination of numbers1 thru 6. Say F32 has the numbers 1, 3, 5, can a formula recognize each of those numbers? |
Count formula problem
I had gotten that far, but let me put it this was, A1 is named
"1-reclassification"with the count formula i want it to find any of the F fields that would contain the number 1, even if one of the F-fields has 1.5.6 in it Can that be done? "Major Tomm" wrote: I have 6 fields numbered 1 thru 6, I want each to look for its own number in a column even if there are multiple numbers in it... A1 to look through F1 thru F2999 which can contain any combination of numbers1 thru 6. Say F32 has the numbers 1, 3, 5, can a formula recognize each of those numbers? |
All times are GMT +1. The time now is 09:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com