|
|
|
|
4 |
116 |
|
|
|
|
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...
|
|
2 |
114 |
|
|
|
June 25th, 2009 02:46 AM
by zipidy
|
0 |
97 |
|
|
|
June 25th, 2009 02:36 AM
by Max
|
2 |
163 |
|
|
|
|
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?
|
|
2 |
145 |
|
|
|
|
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...
|
|
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...
|
|
2 |
117 |
|
|
|
|
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?
|
|
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...
|
|
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...
|
|
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,...
|
|
2 |
101 |
|
|
|
|
12 |
197 |
|
|
|
|
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
|
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
|
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...
|
|
0 |
110 |