LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 32
Default How to add formula like area wise

I Hope some one can help for this formula that I have List of Vehicle details
with approved KM,
My subject is that drivers are running some kilometers but from my company
side we have some approved Kilometer list. Can I put formula as area wise I
mean if area name is TRD that approved KM was added in approve KM cell like
20. Pls find the below some list.

Vehicle No Startng KM Closing KM Total KM Area Aprrove KM
2417 1234 1263 29 TRD 20
1234 3258 3287 29 YUI 22
3214 9874 9903 29 OIU 28
9632 12358 12387 29 UJI 27
1478 3254 3283 29 STR 23
6547 2587 2616 29 KKR 24
9874 1456 1485 29 LLm 29
5821 65896 65925 29 LLO 25
6547 35469 35498 29 GTO 26
3214 14789 14818 29 FTO 24
6589 32145 32174 29 TOL 22
3215 69871 69900 29 KJS 21


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Month wise Sum hsg Excel Worksheet Functions 4 January 27th 10 04:20 AM
How can recalculation be set to "row wise" or column wise" ? Looking for rowwise recalculation Excel Discussion (Misc queries) 0 August 17th 07 10:53 PM
Date wise Sum Formula required Narnimar Excel Discussion (Misc queries) 5 July 4th 07 06:37 PM
Data row wise, formula column wise Fred Smith Excel Discussion (Misc queries) 4 December 9th 05 03:48 PM
Delete row wise duplicates & colomun wise simultaneously excel Dipankar Excel Worksheet Functions 0 October 6th 05 01:14 PM


All times are GMT +1. The time now is 05:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"