multi conditional

Hey folks, Kinda new to this excel thingy so excuse me for being dumb I have about 40,000 products and over 60 categories (or more based on how things are going) is it possible to use a set of defined texts as keywords and show them as categories with , between them? ex: if this cell have these...

Please see below: Column J and I are the ones where I need help with: * Does the customer have one contract with one service type for the entire year? If so, return SYSR (Single Year Single Rev) * Does the customer have one contract with multiple services for the entire year? If so, return SYMR...

=SUMIF(INDIRECT("'"&$C$5&"'!c$12:c$25"),$C$9:$C$22,INDIRECT("'"&$C$5&"'!M$12:M$25")) Currently using this formula to gather information from a spreadsheet which has a large number of tabs, 1 tab = 1 week of the year. The tab name is referred to as c5 in the above formula, the rest is standard...

Hi all, I have been working on a dashboard which will, dependent on a yes/no indicator, require updates from a given user. The dependent variable is in column B, with about 2000 rows. These cells have drop downs with two choices: "No Changes" and "Update Result". "No Changes" is the...

Hello! I am really hoping someone can help me out with an excel question I am stumped on! :) I will do my best to try and explain what I am trying to accomplish. I have a file with 3 different tabs. Tabs 2&3 are purely informational, which I want to pull data from. I need a formula that will...

Hello, Appreciate any pointers/guidance why my multi-conditional formula in excel is not working in the below example. Criteria a. GA < today < EOL : Available, supported b. EOL < today < EOSL : Not available, supported c. Today >= EOSL : Not available, not supported Sample data set B1 =...