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