Search results

Worked like a charm!!!!!!!! Thank you so much @SirJB7 Really really awesome!

@SirJB7 thank you so much for this. Although I don't have time today to test, it will be first thing I do tomorrow morning. I'll check back in and let you know how it goes. Thanks again! -Perry

Hey everyone! My name is Perry and I'm new here. Just wanted to thank everyone for all the help. I work for a small business and I'm in the process of setting up a bunch of systems with in excel to track out daily business. Hope all is well. Talk soon. -Perry

@NARAYANK991 just out of curiosity what would the VBA code look like? I'm not great with VBA but I know my way around well enough to implement the code. For my purposes the pivot table isn't working quiet correctly. Bummer.

@NARAYANK991 & @srinidhi thank you so much. I totally spaced and didn't realize that a Pivot Table would probably be perfect for this. I'll give it a try and let you know how it goes. Thanks a ton!!! -Perry

I have a table A1:J10 with item labels in column A and months across in row one. Within the table each cell has a value, either "Received" or "Requested". I'm looking to create a list with a formula that can look up each cell that is still "Requested" and return the Month and item. For...