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 Jul 13, 2006 10:58 #1 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?
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?
Pondlife Froglike Joined May 2, 2006 Messages 13,861 Likes received 1,635 Thanks received 365 Location Euroland Jul 13, 2006 11:12 #2 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? Click to expand... VLOOKUP to get the two file sizes for each file name and compare the columns.
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? Click to expand... VLOOKUP to get the two file sizes for each file name and compare the columns.
BoredBloke Godlike Joined Jul 6, 2005 Messages 7,235 Likes received 209 Thanks received 41 Location whereever the work is Jul 13, 2006 11:32 #3 LG PM your email and I'll email you the answer. I have a little spreadsheet with what you need in it.
LG PM your email and I'll email you the answer. I have a little spreadsheet with what you need in it.
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 Jul 13, 2006 11:49 #4 Cheers gents. Sorted.