Hello to all,
In column C of the sheet categories how you can tune the unique value
between column A and B of the data sheet?
max_max
Hello to all,
In column C of the sheet categories how you can tune the unique value
between column A and B of the data sheet?
max_max
Enter array formula in C2 and copy down
***Array formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around your formula.
If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi Alakey
is not correct.
In the Column D data sheet, the numbers entered manually are the final result that must be displayed.
max_max
So, where are the numbers 3,5 and 1 are coming from?
My mistake....
the numbers are 3-4-4
Try:
=SUM(IF(A2=Dati!$A$2:$A$5000,1/COUNTIFS(Dati!$A$2:$A$5000,A2,Dati!$B$2:$B$5000,Dati!$B$2:$B$5000)))
Enter with Ctrt+Shift+Enter.
Change formula in C2 to this:
Formula:Please Login or Register to view this content.
then in enter in D2 and copy down
Formula:Please Login or Register to view this content.
Or use just one formula in D2
Formula:Please Login or Register to view this content.
Last edited by AlKey; 09-23-2017 at 09:31 AM.
Hi phuocam
it's right.
a greeting and thank you.
max_max
Hi Alkey
even your new formula is correct.
a greeting and thank you.
max_max
Alkey,
as the new formula puts
IF ($ A2 <> $ A1, SUMPRODUCT ((A $ 2: $ 19 = A2) / COUNTIFS (A $ 2: $ 19, A $ 2: $ 19, B $ 2: B $ 19, B $ 2: B $ 19 & "") ), "")
in cell C2 of the category sheet?
max_max
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks