•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Finding a specific row by a number
I work in a hardware/home goods store. We get reports of open purchase orders of plants by store number.
Is there a way to utilize the four digit store number in another cell as a way to isolate the rows that pertain to my store instead of going through every store's PO in my district? I have tried reordering by ascending/descending but that only sorts that column.
I have been using CTRL-F and find all, which works, but is not the most efficient way to find our 9 digit POs. Hopefully this makes sense, but I can clarify if needed.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#row zero
#open purchase orders
#store number
#four digit store number
#hardware/home goods store
#9 digit POs
#CTRL-F
#isolate rows
#efficiency
#ascending/descending
#reporting
#rows
#district
#sorting
#Excel
#cell