• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Excel help

The Lone Gunman

Tosser amongst Tossers
Joined
Jul 6, 2005
Messages
7,745
Likes received
127
Thanks received
102
Location
Live in Morecambe bay. Currently working in Southe
I know this is easy but I dont do spread sheets.

I have 2 sets of metrics data. Each has 2 columns. File name and file size.

I want to show the differences in file size between like for like file names.

Any offers?
 
The Lone Gunman said:
I know this is easy but I dont do spread sheets.

I have 2 sets of metrics data. Each has 2 columns. File name and file size.

I want to show the differences in file size between like for like file names.

Any offers?


VLOOKUP to get the two file sizes for each file name and compare the columns.
 
LG PM your email and I'll email you the answer. I have a little spreadsheet with what you need in it.
 
Cheers gents. Sorted.
 

Advertisers

Back
Top