Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Need formula that looks in a range for a date and acct #
Thank you...but i'm still having problems. I am going to try and upload the spreadsheet so you can see what I am talking about. The Monthly Data tab is where a .txt file is going be pasted each day. Each day is pasted on the next row (so the sheet will end up being thousands of rows long)...- Wknwrkr
- Post #4
- Forum: Microsoft: Office
-
Need formula that looks in a range for a date and acct #
Is there a formula that looks in a range of cells for both a date and an account # and returns a cell value. I want the formula to say find this date 9/1/08 and this account number 40105-200 and return the cell value in the corresponding column. The dates of the month are in one column, the...- Wknwrkr
- Thread
- Replies: 3
- Forum: Microsoft: Office
-
Status Bar in Excel does not display "calculate"
For some reason my status bar does not indicate when I need to "Ready" nor "Calculate". My setting is on manual calculation. I have very intricate spreadsheets with several tabs and it very frustrating when I have to calculate because it does not indicate when the calculations are complete...- Wknwrkr
- Thread
- Replies: 2
- Forum: Microsoft: Office
