Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
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.