Question description:
This user has given permission to use the problem statement for this
blog.
I have a spread sheet with Items and sub Items. I would like to know if I can place a letter in another column it can get it to list the sub item number on another page in order
Solved by S. H. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
22/08/2018 - 07:38
Hi…Welcome to Got It Pro
User
22/08/2018 - 07:39
ty
Excelchat Expert
22/08/2018 - 07:39
Could you please share your file?
User
22/08/2018 - 07:39
I can't
Excelchat Expert
22/08/2018 - 07:39
is it possible to illustrate some dummy data in the preview sheet on the right?
Excelchat Expert
22/08/2018 - 07:41
So Column A is Item and B is sub-item, is my understanding right?
User
22/08/2018 - 07:42
So I have Section 1, with subsections 1a,1b,1c and so on, in column G I have letters, I would like Rows 14-21 to show sub items only if N of O is used
User
22/08/2018 - 07:43
in order at the bottom if N or O is used
Excelchat Expert
22/08/2018 - 07:44
Where should the N or O be used?
Excelchat Expert
22/08/2018 - 07:44
Please insert the answer that should appear in row 14 to 21 in this example for me to get an idea.
Excelchat Expert
22/08/2018 - 07:46
Are you saying you want only those sub-sections which indicates N or O in Column G?
Excelchat Expert
22/08/2018 - 07:47
ok...got you.
Excelchat Expert
22/08/2018 - 07:47
Let me build the formula. This will be an array formula.
User
22/08/2018 - 07:47
No sub item at the bottom if y is used
User
22/08/2018 - 07:47
Thank you so much
Excelchat Expert
22/08/2018 - 07:48
Yep
Excelchat Expert
22/08/2018 - 07:55
Its taking a little longer to process array formula. Please do extend the time when it prompts.
User
22/08/2018 - 07:55
done
User
22/08/2018 - 08:06
Going to be much longer?
Excelchat Expert
22/08/2018 - 08:06
Sorry about the delay
Excelchat Expert
22/08/2018 - 08:07
I am trying to get both criteria and its kind of erroring out. But this should work. Please give me a little more time.
User
22/08/2018 - 08:07
Ok I have like 5 more mins before I have to leave for work
Excelchat Expert
22/08/2018 - 08:09
ok..if that's the case, I will send the completed file through our support to your email.
User
22/08/2018 - 08:09
awesome thank you so much
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.