Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 12 January 2023
  0 Replies
  1.3K Visits
0
Votes
Undo
I have a list of data that shows assets (Sub-Object) being used by another asset (Object). All of this data spans over 140 092 rows in excel when exported from our software.

Currently I am using "Find" to locate the "Sub-Asset" and then manually looking upwards for the "Main-Asset" number and then moving on to the next one, rinse repeat until I return to the first value returned.

I was wondering if there is a way to create a function either a basic excel function or using a VBA macro as I am somewhat familiar with this.
There are no replies made for this post yet.