I need to compare room numbers and areas from an external excel spreadsheet. I was hoping to get a True/False list as result - does the room number appear in the model, and does it have the same area value? I have to use Room Number as ID, because the index lists do not match - see attached
Is it also possible to create a True/False data marked with a color for each comparison? Or is it just easier in excel. This would help me with a good overview.
I have now imported, filtered and sorted the data that I want to work with, but now I am stocked. Is my work until now ok? And how do I get started with the comparison, and export.
Thank you guys!
RoomCHECK.dyn (38.2 KB)