• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Combination Method

Hi,
Greetings from Raju....

need one clarification reg the how can i create the combination factor and the which formula when am use it will get the date from second or other sheet.

like

SITE TYPE PRIORITY Desk
All All All All
APJ Incident Critical IBM
EMEA Request High CTS
AMS Medium TCS
Low INFY
ACCE
combination factor like:
1.AllIncidentHighTCS
2.APJRequestLow
3.AMSAllCTS
kindly help the above am created the manual combination factor, how can i create the automation and also get the value from 2nd sheet.
Thanks in Advance
Raju
 
I'm afraid it's unclear (to me) what you are trying to describe. Could you upload an example workbook showing what you have, and what you'd like the formula to produce?
 
Good day Raju

I think forum members would have a better chance of knitting fog than understanding what you need
 
Hi Luke ,

I guess what Raju wants is a listing of all the combinations given the 4 fields viz. SITE , TYPE , PRIORITY and DESK.

SITE probably has 4 variations viz. All , APJ , EMEA and AMS
TYPE has 3 variations viz. All , Incident and Request
PRIORITY has 5 variations viz. All , Critical , High , Medium and Low
DESK has 6 variations viz. All , IBM , CTS , TCS , INFY and ACCE.

Now , OP wants all possible combinations of the above , considering one from each e.g. APJ Incident High and CTS is probably one valid combination.

Narayan
 
Back
Top