Please see attached !!!!
I would like to assign a logic code, N, A, B, C to numbers in column B
Please see attached !!!!
I would like to assign a logic code, N, A, B, C to numbers in column B
Last edited by AliGW; 07-09-2019 at 01:27 AM.
Hmm, sorry, I don't know what you are asking. Hopefully someone else does.
Sorry for off-topic interjection:
Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.
Even having looked at your workbook, I have NO CLUE what the logic is here. You are going to need to explain it again, anyway.
Last edited by AliGW; 07-09-2019 at 01:30 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
If in Column B, I have 6 Numbers(F2), then this is the LOGIC in Column C : 3=6/2 are N then rest 3=6/2 : one A, one B, one C
So in Column B, find number in C2 then beginning that N A N B N C
If in Column B, I have 12 Numbers, then this is the LOGIC in Column C : 6=12/2 are N then rest 6=12/2 : two A, two B, two C
So in Column B, find number in C2 then beginning N N A A N N B B N N C C
If in Column B, I have 18 Numbers, then this is the LOGIC in Column C : 9=18/2 are N then rest 9=18/2 : three A, three B, three C
So in Column B, find number in C2 then beginning N N N A A A N N N B B B N N N C C C
So in FIRST case, start assigning N to number corespponded in C2, continue down and then continue from top
In B I can have, 6,12,18,24,30 max options
Last edited by ionelz; 07-19-2019 at 04:28 PM.
Sorry, still don't understand what you're asking...
Please try at C4
Formula:Please Login or Register to view this content.
May I ask what are you applying this to?
Like always, thank you so much.
You are really unbelievable !
It is exactly the same, you did once before.....
You write a formula to 'PLUG" single/u shape in diagram
I am extracting some of them in B and assign a code...
I need a formula at B4. I want to look in Range I4:P75, then in each Row , Row I4:P4 and if B3 is there then write H4
Please try at B4
=IFERROR(AGGREGATE(15,6,$H$4:$H$75/($I$4:$P$75=$B$3),ROWS(B$4:B4)),"")
Thank you !
This question should be simple : I want to put Codes Back : Column C4:C33 to Row S3:CL3!
So I want Formula at S3
Please try at S3
=IFNA(VLOOKUP(S2,$B$4:$C$33,2,0),"")
Bo, THANK YOU so much !!!
I may have more questions...if you do not mind
In Formula #6, there is ... {"A","B","C"} ....
How this formula become if A,B,C are defined in Cells A1,A2,A3 (A1=A , A2=B, A3=C) ?
Change {"A","B","C"} to $A$1:$A$3
Thank you !
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks