LinkBack URL
About LinkBacks
Good Morning,
I would much appreciate if someone can assist with an excel formula to show howmany hits when checking certain rows against data list,
and the result should be on the same row, like in the attached workbook.
Thanks
sem
EXCEL Formula to show howmany hits when checking list against data?
Good Morning,
I would much appreciate if someone can assist with an excel formula to show howmany hits when checking certain rows against data list,
and the result should be on the same row, like in the attached workbook.
Thanks
sem
hi sem, are the desired results you want in Column M:R? Could you explain how they are obtained?
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hi Benishiryo,
Thanks for your time,Yes .By checking "G3:K3" against "A3:E26" and you'll find "M3:R3" result, for the second resulthi sem, are the desired results you want in Column M:R?
you'll check "G4:K4" against "A3:E26" and result would be "M4:R4" and so on.....untill "G26:K26" by checking against "A3:E26"
and the result in "M26:R26".
I hope i explained clearly.
thans again and have a good day.
Sem
Why there is 0 in N4? and what's the red numbers represents?
Hi Devilk,
thanks for your time,
that "0" is if there are no match when comparing "checking" "G3:K3 all the way to G26:K27"against the data (A3:E26)Why there is 0 in N4? and what's the red numbers represents?
so if there are matches in the data to show under those red numbers.
thanks
sem
There is not data in K27...Originally Posted by sem
So M3 is the number of time whole row G3:K3 exist in A2:E26/
So N3 is ...
O3-
P3-
Q3-
R3-
Can you add explanation,please?
Good Morning Devilk,
thanks for trying to help me i really appreciated.
You're right there are no "K27" it typo its "K26" sorry.
I formatted how the numbers match in "A3:E26" data.
So for "G3:K3" You'll have 1 row with 5 numbers,1 row with 4 numbers,1 row with 3 numbers,3 rows with 2 numbers,
10rows with 1 number and 8 rows with no matching numbers at all in "A3:E26" data.
And for "G26:K26" it would be 1X5,1X4,0X3,7X2,9X1 and 6 rows with no matching numbers .
I hope i explained my problem,and thank you for your patience.
Sem
Hi,
If its not possible with excel formula i dont mind the solution with UDF or VB code
please.
much appreciate any suggestion.
Thanks
Sem
Bump........?
Any ideas...?
HI,
I think i foun solution for the "G3:K3" by using helper column and i get correct result in "m3:R3",
when i move down To "G7:K7" i get correct result in "M7:R7" but all the previos result change as well i get same result
in "M3:R7"rows??? if you kindly assist me why this is happening?
Thank you
Sem
Suggestion Please..?
your new column for Hits is only catered for the combination:
3 31 41 44 45
if you want to use this method, you have to do another 23 columns of HITS to cater for the rest of the combinations & i dont think that's ideal.
Hi Benishiryo,
Thanks for time, you're right about the helper column my list is very long i may need more than 23 column so itsnot ideal
for me .that is why i need vb code .
thanks againand much appreciate your help.
Sem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks