Forum Discussion

Copper Contributor

Apr 15, 2022

Excel help sorting.

Good afternoon, hope someone can help. so here goes. i have a spreadsheet that has 8 columns the first Column is a list of companies named and numbered starting in A6 down to A52. Then I have fou...

excel

Formulas and Functions

Rvan44

Copper Contributor

Apr 17, 2022

OliverScheurich
Happy Easter! So I kept messing with it after I posted the reply. I ended up deleting the file and made a new copy of my master sheet. So I knew it would be 100% clean. Meaning no left behind functions I tried before I asked help on this forum.

and you are correct it works flawlessly.

Thank you so much for your patience and help. ( and that goes for everyone who responded ) Now have another question or maybe 2.
Can I put this on sheet 2 and let it grab the information from sheet 1?

and to make it more legible can I return a blank cell for any value that does not match my search criteria?

PeterBartholomew1

Silver Contributor

Apr 17, 2022

Rvan44

To move stuff from sheet 1 to Sheet 2, grab the region you wish to move with a mouse select and use Ctrl/X for 'Cut'. Turn to sheet 2 and type Ctrl/V in the corresponding location. Assuming you are using FILTER, the function contains another parameter which allows you to return a message or, even, to perform an alternative function.