How to make a comparison between Arrays?
problem:
at school when we have to request material we have to request it from different suppliers, when I have the suppliers' estimates I use Excel and in each sheet I insert the order-type estimates for each supplier. each supplier must create a quote for the same material.
I therefore thought of converting everything on fwh and making up to 5 xbrowses, probably better a folder with an xbrowse each, so for example 5 Arrays will be formed where in each of them the fields will be listed (desc, VAT, unit price, row total ) how could you make a comparison between the 5 Arrays?
for example compare prices or check whether the supplier has offered a specific item requested or with a compatible one.
This is the work we often have to do and I do it with Excel but I struggle because then I have the articles in one archive, the supplier estimates in another... if I had everything in one application perhaps I would save time.