What method/function to use for determining values in 2 columns

[Jodi]

I'm a Web Analyst and I have some database data I'm analyzing. I created a pivot table that summarizes order number and the columns are footwear, apparel, etc. For each order it gives a number of apparel and footwear items purchased. I am wanting to pull out what orders there are values for in both footwear and apparel but I'm not sure the best way to do this. So, which orders contain values for both footwear and apparel? Can anyone help?

 

[Bhawani]

You'll need to upload sample excel file.

 

[Jodi]

Look at Example sheet, I'm wanting to call out orders where values are present for both footwear and apparel. Ideally, It would be columns like this - order number, Apparel and Footwear = 1. Make sense?

I may have come up with an easy solution playing around with my pivot table on sheet 1 though. Just trying to figure out the easiest way to call out orders that contained both apparel and footwear but not sure of the proper/easiest/fastest method.

Thanks in advance for your help!

 

[vrunda]

Find the file , if it suits ur requirement.
I just changed the row labels to column

 

[Jodi]

I'm not seeing what you did...

 

[vrunda]

I think i have not understood exactly what do u want. Secondly which is ur data sheet from which u want the report i.e. ur solution

 

[NARAYANK991]

Hi Jodi ,

See if this helps ; there are formulae in columns J , K and L.

If there are numbers in column L , they signify that that particular order had both footwear and apparel in it.

Narayan

 

[vrunda]

Narayan Sir Answer is correct n working

 

[Jodi]

Thank you sooo much! I'm working on getting better at using functions and using multiple functions. I appreciate you guys' help!

Jodi