Question description:
This user has given permission to use the problem statement for this
blog.
I need to find if an array c10 thru g10 contains a number, then return either a X or leave it blank
Solved by C. W. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
31/03/2018 - 06:08
Hi there
User
31/03/2018 - 06:08
Hi
Excelchat Expert
31/03/2018 - 06:08
How are you and how may i assist you with today?
User
31/03/2018 - 06:10
OK, Column a thru say e, each line has an array of number from 1 thru 20: I want to put 1 thru 10 on line 1, columns g------: I want to be able to say is 6 in the array (a - E),, if so, then return an "x" if not leave blank
Excelchat Expert
31/03/2018 - 06:10
Okay, i will try my best to help you out with this
Excelchat Expert
31/03/2018 - 06:10
Can you share me a sample worksheet
Excelchat Expert
31/03/2018 - 06:10
So that we both can have a better evaluation to the issue
User
31/03/2018 - 06:10
can I type on the spread sheet on the screen
Excelchat Expert
31/03/2018 - 06:10
Yep sure
User
31/03/2018 - 06:13
So ..... I want the x in the 2, (h column), also the 16, 18 and 7, but not in the 1, 3 or 5
Excelchat Expert
31/03/2018 - 06:14
Okay so what would be the criteria for that?
User
31/03/2018 - 06:14
I have about 150 lines, and I need to see a representation of the patter going down - at a glance
User
31/03/2018 - 06:14
sorry, pattern
Excelchat Expert
31/03/2018 - 06:15
On what criteria we shall have those X to put up
User
31/03/2018 - 06:15
I'm sorry I don't understand your question
Excelchat Expert
31/03/2018 - 06:16
based on some fixed numbers like 2,4, 7 we shall get X? or how should the X come in?
Excelchat Expert
31/03/2018 - 06:17
pattern in the sense are those prime numbers?
User
31/03/2018 - 06:17
I want to say that the Number 5, 2, 16, 18 and 7 are x's. Then again I want to be able to see when those number would repeat....is taking 2: it repeats on line 6, lin 20, line 23, 24 and 50
User
31/03/2018 - 06:19
That formula doesn't work, it's not putting an "x in the column "H" and nothing in colum "g"
Excelchat Expert
31/03/2018 - 06:19
M not able to get it, can you be more specific step by step
Excelchat Expert
31/03/2018 - 06:21
Means If H3 is X then in B4 you want to see X?
User
31/03/2018 - 06:21
OK. I want to look at the array on line 3: we have a 5, 2, 16, 18 and 7: I want an X under the columns K, H, M etc..., then on line 4, I want to do the same with the next set of numbers
Excelchat Expert
31/03/2018 - 06:22
Okay, i think i got it now
User
31/03/2018 - 06:22
OK
User
31/03/2018 - 06:25
Do I use the "match" function? If so, how do I make that formula say X in the appropriate column and leave the other blank?
Excelchat Expert
31/03/2018 - 06:26
Will get you the appropriate formula, just give me a while
User
31/03/2018 - 06:26
OK - thanks
Excelchat Expert
31/03/2018 - 06:31
Hey
User
31/03/2018 - 06:31
hello
Excelchat Expert
31/03/2018 - 06:31
Its done
Excelchat Expert
31/03/2018 - 06:31
:)
User
31/03/2018 - 06:32
OK, how do I do this?
Excelchat Expert
31/03/2018 - 06:32
will share you the sheet shortly
User
31/03/2018 - 06:32
ok
Excelchat Expert
31/03/2018 - 06:36
Please have a look
[Uploaded an Excel file]
Excelchat Expert
31/03/2018 - 06:36
is it nice
User
31/03/2018 - 06:36
Looks great - I'll try it - thanks so very much. I appreciate your help. Have a great day
Excelchat Expert
31/03/2018 - 06:37
Please do a valuable rating for me
Excelchat Expert
31/03/2018 - 06:37
that will help me a lot
User
31/03/2018 - 06:37
OK will do....ciao,
Excelchat Expert
31/03/2018 - 06:38
If you really like it then please put up some good words, for me :)
Excelchat Expert
31/03/2018 - 06:38
Thanks for being in Got it Pro!
User
31/03/2018 - 06:39
where do I put the "comments"
Excelchat Expert
31/03/2018 - 06:39
Have a nice day!
Excelchat Expert
31/03/2018 - 06:39
After you click on end session
Excelchat Expert
31/03/2018 - 06:39
you will get the options :)
Excelchat Expert
31/03/2018 - 06:40
Are you there?
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.