A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Calc with time by Maria Soto
I need sum cells with time. I have this case: A1=15:17 and A2=23:04 When I sum A1+A2 the result is incorrect: =Sum(A1:A2) = 14:21 Why???? Thank you.
October 9th, 2003 12:53 AM
by Andi Go to last post
4 122
Function to find value in cell by Ken Wright
If you just want the last value in the column, regardless of whether or not you have any blanks in your data, then the following will both do...
October 9th, 2003 01:10 AM
by Harlan Grove Go to last post
9 303
HLOOKUP by Steved
Hello from Steved =HLOOKUP(A1:B1,C4:AT125,3) would like it to be =HLOOKUP(A1:A2,C4:AT125,3) The above formula works fine on A1 I want to change B1 in the...
October 9th, 2003 01:26 AM
by Max Go to last post
4 197
Macro: How Can I Repeat Macro In Other Cells?? by Cloudhopper
I am referencing data in an Excel inventory spreadsheet with over 20, 300 lines. I have written a macro that will reference information from a cell in...
October 9th, 2003 02:34 AM
by Laura Cook Go to last post
1 355
Date stamping entries by Dino
I hope that someone can help me with this: I am setting up a 20,000 item spreadsheet, where my staff will put an "X" in an adjacent column when they are...
October 9th, 2003 02:52 AM
by Gord Dibben Go to last post
2 139
Discount table by Max
Nothing wrong as far as your VLOOKUP set-up is concerned. Take it that the VLOOKUP cells are formatted as percentages. Kanga...
October 9th, 2003 02:58 AM
by Laura Cook Go to last post
1 203
unlocked cells in a protected worksheet by mscpa
I have my excel worksheet protected except for the cells that will be used for data entry. In an older version of excel, when I pressed the tab or enter key,...
October 9th, 2003 03:15 AM
by Dave Peterson Go to last post
1 396
Data in A1:A5 to A6:F6? by Clipper-44
Is there a quick way to fill a row, say A6:J6 with data from a column, say A1:A10? I have a worksheet with eventdata in columns, event-1 in cells A1:A35,...
October 9th, 2003 03:24 AM
by Gord Dibben Go to last post
2 112
workbook references by Marie
I have a folder containing various Excel files that are linked to one another. I recently had to move the entire folder to another location. In the...
October 9th, 2003 03:37 AM
by [email protected] Go to last post
4 123
basic question!!! by sylvain
Hello, I have a simple question, I tried to look in help but no result. Here is my problem I want to take a value from another worksheet. display cell's...
October 9th, 2003 06:19 AM
by Paul Simmons Go to last post
5 151
Re HLOOKUP by Steved
Hello from Steved the below formula came fom Max Please I am learning my way round so please bear with me =HLOOKUP(A1,C4:AT125,A2,FALSE)it is returning...
October 9th, 2003 06:37 AM
by Max Go to last post
5 98
October 9th, 2003 08:13 AM
by EVS Go to last post
0 101
Display Binary data ( an OLE object field in Access database) to Excel Cell by Koo
Hi, I'm using Office XP now and I store images in my Access database with a OLE object data type field. Now I wish to display the image binary data (retrieve...
October 9th, 2003 09:43 AM
by Koo Go to last post
0 591
Protecting Macros (Excel2000) by Ed Beattie
Help!!! I'm trying to incorporate a password protected worksheet function into a macro with little or no success. I've have quite easily incorporated a...
October 9th, 2003 11:15 AM
by Harald Staff Go to last post
1 177
Extracting information by Jill Berry
I have data from Alpha 4 (DOS Database). I have already exported the data and the following is an example of what I would like to do: We currently bill our...
October 9th, 2003 11:34 AM
by Andy Brown Go to last post
1 100
if function for text color by sashraf
How can I right an if formula for various text but it has a consistant color? Thanks
October 9th, 2003 01:10 PM
by Debra Dalgleish Go to last post
1 78
process a list through a cell by Tim
I am trying to reproduce / simpilify what the solver and goal seak tools do. I have one cell (input) that I want to recieve values from a list. There is...
October 9th, 2003 01:26 PM
by Bernie Deitrick Go to last post
1 210
conditional formatting by Jack
Hi, In conditional formatting is there a way to format cells to "Blue" if the cell is a value and "Black" if the cell is a formula. If it is not possible, any...
October 9th, 2003 01:35 PM
by Paul Go to last post
1 111
Passing Variables into a Link by Alec
I have written VB code that, on the press of a pushbutton, creates new sheets from a template, it also puts the sheet name in cell A1 of the new sheet. I also...
October 9th, 2003 02:12 PM
by Alec Go to last post
4 261
finding a way to extract information to a new worksheet by Amelia
Can I label infomation on one sheet and have it extrapolate to a second. example: MARCH Today Orange 1 purple 99 tomorrow green 93 Yellow 7
October 9th, 2003 03:12 PM
by Amelia Go to last post
3 99
Post New Thread


Display Options
Showing threads 1081 to 1100 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:04 AM.


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