multi row

keepcalm

hi ,

I am trying to use a multi row formula where if falls under same receipt number and under usage it contains "Home" i want the all fields to reflect as "Y". Below are the desired output. Any help?

Receipt	Usage	Contain Home?
123	Home	Y
123	Work	Y
123	Misc	Y
111	Home	Y
111	Work	Y
222	Work	N
222	Misc	N

IraWatt

Hey @keepcalm,

Here's how I would do that:

I think a summarize and join works better then a multi row in this example. Please ask if any questions

HTH,

Ira

Y or N.yxmd