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
Finding the first value that is less than zero by russhess8
I have a list of values in column b. I want to find the first time that this value is less than zero. I then want to list the corresponding row in column...
June 25th, 2009 03:19 AM
by T. Valko Go to last post
4 116
VLOOKUP returning a #VALUE! error and I've not idea why! HELP!!! by forevertrying
Hi there, I am using VLOOKUP to calculate vehicle usage hours... or should I say, I am TRYING to use. It keeps sending back a #VALUE! error and I have...
(Multi-page thread 1 2)
June 25th, 2009 03:15 AM
by Scarlett Go to last post
18 294
Reconize the first digit only by Steved
Hello from Steved Please how do I ask the below to except the first digit in this case "Wiri" for example 4111, 4521, 4321, 4976 and so on, will return...
June 25th, 2009 02:48 AM
by Jacob Skaria Go to last post
2 114
Printing spreadsheet print area to 1 page fails to shrink image en by zipidy
Print scaling fails to shrink image enough to print on one page (even though Print Preview shows the data fitting in one quarter of a page). If I try to...
June 25th, 2009 02:46 AM
by zipidy Go to last post
0 97
Comparing dates from VLOOKUP functions not working right by Sambonator
I have a spreadsheet with a bunch of VLOOKUP functions that pull dates from different sheets. When I try to compare the dates I get incorrect results. E.g....
June 25th, 2009 02:36 AM
by Max Go to last post
2 163
June 25th, 2009 02:34 AM
by Fred Smith[_4_] Go to last post
1 73
Hide row based on cell value by Munchkin
Colum C shows a date. If the date shown is older than 4 years I want the row to be hidden. Is it possible to do this?
June 25th, 2009 02:21 AM
by Jacob Skaria Go to last post
2 145
How can I create a simple form where users can tab between fields by DMAC
Without the ability to alter the rest of the spreadsheet
June 24th, 2009 11:06 PM
by Gord Dibben Go to last post
1 92
Row Height-expand if text wraps in a cell by Penny Miller
I have a worksheet that has a comments column that is formatted to wrap text if needed for each cell. My problem is I need the row to automatically adjust...
June 24th, 2009 11:05 PM
by Gord Dibben Go to last post
3 114
Pulling data from Sheets in A workbook by MRSVATEK
I have 100 sheets with the same layout that I want to summarize on a master worksheet. The cell references are the same on all 100 sheets so it is easy to...
June 24th, 2009 11:03 PM
by Gord Dibben Go to last post
2 117
Auto enter current date in cell when another changed by Andy Smith[_2_]
Is it possible to have excell automatically enter the date into a cell when changes are made to another cell? (I do not want this date to update so I don't...
June 24th, 2009 10:53 PM
by Gord Dibben Go to last post
7 153
Sum function by dannyboy8
If i have a row of positive and negative #s, and I want to sum up this row, but only include the positive #s in the sum, how would I go about doing this?
June 24th, 2009 10:41 PM
by Gord Dibben Go to last post
3 174
sum/autosum not calculating correctly by websterk12
When I add numbers in a column, sometimes I'm not getting the correct total. I've cleared the cells of all formuals, and have re-entered the SUM formula...
June 24th, 2009 10:39 PM
by Gord Dibben Go to last post
6 162
Formula for 0 by Fareez
Dear Friends I want to find out 0 value and delete that columns say for ex 45862 0 46502 0 47449 0 48002 0 in this example i want to delete all columns which...
June 24th, 2009 10:24 PM
by Gord Dibben Go to last post
4 149
Vlookup function wont work for copied data by Scarlett
I have copied a table from another source. I am trying to do a vlookup for a column against this copied table. However N/A is returned. I tried TRIM, CLEAN,...
June 24th, 2009 10:20 PM
by Gord Dibben Go to last post
2 101
Count a number in a range with cells containing more than one numb by Vermont Pete C
I've got a range (one column) where each cell either - has no value or number in it (empty cell) - has 1 or more values in it (and I can separate by , ; - / or...
(Multi-page thread 1 2)
June 24th, 2009 09:52 PM
by T. Valko Go to last post
12 197
Return Value using If statement or Lookup? by Malva
I have column a1 thru a100 are pass/fail values, column b1 will return a "fail" if any of the rows in column a1:a100 has a "fail" value. Do you have a if...
June 24th, 2009 09:42 PM
by Rick Rothstein[_2_] Go to last post
2 94
hyperlink to another doucment and open it by Fred
I have an excel spreadsheet with 6000 rows in it. Each row represents a document style. I wish to link from excel to images of each document. I can do it...
June 24th, 2009 09:25 PM
by Fred Go to last post
2 90
specify data size in cell add 0's by donna13pa
I want to specify that if data I am importing is 5556946581 it will return as 0000005556946580. It will add 0's to the beginning to make the length 16...
June 24th, 2009 08:41 PM
by Mike H Go to last post
2 237
Excel lock / Notify feature malfunctioning by andrei999
At our workplace we have a master Excel workbook that accessed daily by sales personnel. Each person has to make entries that they responsible for. Once...
June 24th, 2009 08:39 PM
by andrei999 Go to last post
0 110
Post New Thread


Display Options
Showing threads 9781 to 9800 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 09:27 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.