Welcome!

Formula to return more than one value - Please help!!!!!

=INDEX([Job Name]1:[Job Name]15, SMALL(IF([Job Number]22=[Job Number]1:[Job Number]15, ROW([Job Number]1:[Job Number]15)-ROW([Job Number]1)+1), ROW(1:1)))

Find more posts tagged with

Formulas

Comments

Paul Newcome

I'm not sure I follow. What exactly are you trying to accomplish? Can you provide more details?

Sign in to join the conversation!

Quick Links

Trending discussions

Query: Extract Day (Thu) from Date Column
Hi, this column is a date column. I need to extract the day (like Thu) from it for each row. Could you please suggest a formula?
Automation Change Cell Value not working, but working when Test run
I have a Checkbox (Flag) which should change the Value in a Drop Down List to specific Value, which is with formula then referring to shorter Offset days according to a supporting sheet. When I do a Test run of the Automation it works, but when I manually check the Box, its not changing the Cell Value. INDEX(COLLECT…
Formula to Display Weekday Horizontally
Hi, I have a sheet where i am trying to pull the weekday horizontally based on the dates.But I am unable to fix the formula.Can anyone suggest what formula to use