Condition 1
E column : Construction order No , Corresponding to column B
Condition 2
F column : Construction order , Corresponding to column C
Find out that column A is not repeatedly placed in G2:T6 ranges
Any help would be appreciated !
Condition 1
E column : Construction order No , Corresponding to column B
Condition 2
F column : Construction order , Corresponding to column C
Find out that column A is not repeatedly placed in G2:T6 ranges
Any help would be appreciated !
Last edited by Sakurayuki; 12-27-2020 at 09:31 AM.
Hi, you should take a ook at the built in COUNTIFS() Function and the INDIRECT() function.
It can easily done with VBA but in Formulas it will be a little more complicated.
Last edited by Keebellah; 12-24-2020 at 03:51 AM.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Hi Sakurayuki,
Try below code ...
Please Login or Register to view this content.
Last edited by nankw83; 12-24-2020 at 03:57 AM.
If I was able to help, you can thank me by clicking the * Add Reputation under my user name
Just for the fun of it...Here is an array option...For large data set Dict is better though...
Please Login or Register to view this content.
Last edited by Sintek; 12-24-2020 at 08:19 AM.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
I appreciate both of your answers,
Thank you very much both for providing the code, the question is finally answered satisfactorily, you are both too good
Glad to help & thanks for the added Rep.
.........................
Thanks.png
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks