1 min readfrom 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.

submitted by /u/AChrapkiewicz
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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