Excel help

The Lone Gunman

Tosser amongst Tossers

The Lone Gunman has more data than eek

Join Date:

Jul 2005

Location:

Live in Morecambe bay. Currently working in Southern Germany.

Posts:

7745

Thanks (Given):

0

Thanks (Received):

102

Likes (Given):

0

Likes (Received):

127
#1

Excel help

13 July 2006, 09:58

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 am not qualified to give the above advice!

The original point and click interface by
Smith and Wesson.

Step back, have a think and adjust my own own attitude from time to time
Tags: None

Reply With Quote
Pondlife

Froglike

Pondlife - scorchio!

Join Date:

May 2006

Location:

Euroland

Posts:

13803

Thanks (Given):

151

Thanks (Received):

349

Likes (Given):

918

Likes (Received):

1,614
#2

13 July 2006, 10:12

Originally posted by The Lone Gunman

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.
Reply With Quote
Comment
BoredBloke

Godlike

BoredBloke 's job has never been outsourced

Join Date:

Jul 2005

Location:

whereever the work is

Posts:

7231

Thanks (Given):

10

Thanks (Received):

41

Likes (Given):

10

Likes (Received):

209
#3

13 July 2006, 10:32

LG PM your email and I'll email you the answer. I have a little spreadsheet with what you need in it.

Rule Number 1 - Assuming that you have a valid contract in place always try to get your poo onto your timesheet, provided that the timesheet is valid for your current contract and covers the period of time that you are billing for.

I preferred version 1!
Reply With Quote
Comment
The Lone Gunman

Tosser amongst Tossers

The Lone Gunman has more data than eek

Join Date:

Jul 2005

Location:

Live in Morecambe bay. Currently working in Southern Germany.

Posts:

7745

Thanks (Given):

0

Thanks (Received):

102

Likes (Given):

0

Likes (Received):

127
#4

13 July 2006, 10:49

Cheers gents. Sorted.

I am not qualified to give the above advice!

The original point and click interface by
Smith and Wesson.

Step back, have a think and adjust my own own attitude from time to time
Reply With Quote
Comment

Excel help

Comment

Comment

Comment

Partners

Advertisers

Contractor Services

CUK News

Excel help

Excel help

Comment

Comment

Comment

Partners

Advertisers

Contractor Services

CUK News

Tag Cloud