LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 989
Default Formula Needed

I have two worksheets named "Business" and "Information"
In "Business" there are three columns.
Column A has dates in dd/mm/yy format going through to 2020.
Column B has descriptions such as hotel, petrol, expenses etc.
Column C has the price for the item.

On the "Information" worksheet I would like to pull the details from the
"Business" worksheet so that I can get a price for example on "hotel" in
column B between two dates in comlumn A with a total on the price in column
C. The dates from column A need to be specific to the month and year.

Many thanks in advance for all your help.

Mark
 
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
Formula Needed Clark Excel Discussion (Misc queries) 3 October 3rd 07 08:14 PM
FORMULA NEEDED Kerri Olsen Excel Discussion (Misc queries) 5 July 16th 07 08:12 PM
Formula Needed lsmith Excel Discussion (Misc queries) 1 June 8th 06 09:12 PM
Formula, Help needed themax16 Excel Worksheet Functions 2 May 22nd 05 06:55 PM
Formula needed plfry Excel Worksheet Functions 7 January 5th 05 10:43 PM


All times are GMT +1. The time now is 11:20 PM.

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

About Us

"It's about Microsoft Excel"