Posted to microsoft.public.excel.misc

robbie

external usenet poster

Posts: 26

Lookup / max & min functions

I am trying to get a min and a max value in column C for the various
Registrations in column B in a spreadsheet - Excel 2003. ie trying to get the
first and last kilometer reading of the month per vehicle. Please can you help

A-DATE B-TRUCK REG C-KILOMETERS D-DIESEL FILLED
1 1/5/08 JWY467GP 10000 1000

2 5/5/08 PTS030GP 5000 500
3 6/5/08 MVT537GP 2000 250
4 7/5/08 JWY467GP 12000 1000
5 10/5/08 PTS030GP 6000 500
6 12/05/08 MVT537GP 2500 250

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
lookup functions	Srinivas	Excel Discussion (Misc queries)	5	April 1st 08 02:59 PM
lookup functions	jai	Setting up and Configuration of Excel	1	April 17th 07 01:02 PM
Lookup functions	arnoberg	Excel Worksheet Functions	4	July 8th 06 05:31 PM
Lookup Functions	nick	Excel Worksheet Functions	3	October 11th 05 04:02 PM
LOOKUP functions?	MIKDU	Excel Worksheet Functions	4	April 28th 05 02:40 AM

All times are GMT +1. The time now is 06:42 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us