Sign in to join the conversation:
=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)))
I'm not sure I follow. What exactly are you trying to accomplish? Can you provide more details?
Hi i'm looking to a formula using INDEX and MATCH to refer data from two sheets. i have 2 source sheets sheet: "project" and "Archive projet". in each, there are same columns for projet number and contact name. i would like to refer the contact name in a third sheet with a formula that can find the contact name based on…
I am seeing if I find a match for a value in a multi select column and using the HAS formula. It is returning when the string is found, but also when a string plus additional words is found. For example I am looking for if the color "red" has been selected in the column, but it is also pulling in when "Red Rose" has been…
Hi, I’m trying to set up conditional formatting in my plan and need some help combining two conditions. Scenario: If the T-Start Date is in the past, I want the date to turn red. However, if the Status cell is Green, I want the T-Start Date to show as green instead of red (so the Green status overrides the red formatting).…
