|
|
Move data by
Its me[_3_]
Hi to all
I am a new user to Excel and I have a list of data that is in 6 lines per
record that I want to move to 6 separate columns per record - can this be...
|
November 29th, 2009 04:37 AM
by JLatham
|
2 |
111 |
|
|
repeating values by
Peach
I have this formula to calculate my value balance:
=IF(ISBLANK($C5),$O4-$D5*$L5,$O4+$C5*$L5)
This works but when I copy my formula down the column I get...
|
November 29th, 2009 02:45 AM
by JLatham
|
1 |
92 |
|
|
|
|
5 |
154 |
|
|
Adding digits with moving decimals by
Loadmaster
Cells U2:AC2 have 1000-9000 lbs. Cells S3:S14 have Compartments B thru M
Cells U3:AC3 have the following figures corresponding the weights above.
7.3 for 1000...
|
November 28th, 2009 08:41 PM
by Mike H
|
2 |
127 |
|
|
USING SUMPRODUCT by
Trevor Aiston
I have a workbook of attendees and their results on a course evaluation sheet
for each day,
In the workbook there are two worksheets
Attendees which...
|
November 28th, 2009 08:21 PM
by Max
|
2 |
109 |
|
|
Splitting text divided by carriage returns by
Phil H
I have a report in which multiple responses are provided in a single cell.
The responses appear on different lines as if these had been added with a
carriage...
|
|
2 |
107 |
|
|
Comparing text strings by
Comparing columns with text
I have two columns populated with names and I need to compare them for
duplicates. Some duplicate names may contain middle initial or middle names
and some...
|
|
5 |
91 |
|
|
|
|
0 |
91 |
|
|
|
|
2 |
100 |
|
|
adding next years value by
tleehh
i would like to add all the values in month of january of 2010 in colume D.
i am using formula as follows but does not...
|
|
3 |
94 |
|
|
Autofilter not grabbing last row by
Elaine
When I autofilter a criteria, it also includes the last row of data, which
shouldn't be included as it doesn't meet the criteria. For example, to
autofilter...
|
|
2 |
132 |
|
|
|
|
1 |
80 |
|
|
|
|
6 |
103 |
|
|
Access-Excel querry problem by
Eva
Hi
I created two days ago access data base then today I wanted to link one
querry to excel by
Data/Import external data/import data
And I can only see the...
|
November 27th, 2009 08:16 PM
by Eva
|
0 |
90 |
|
|
|
November 27th, 2009 06:55 PM
by T. Valko
|
4 |
106 |
|
|
upgrading to office 2007 by
Rainest
After installing office 2007, some of my excel office 2003 spreadsheets have
lost their formats. Can someone help?
|
November 27th, 2009 06:07 PM
by Lobster
|
2 |
98 |
|
|
Lists, lookup, if??? by
QChris
Hi,
A new user to this site. Been learning a lok lately, but stuck now!
I have a sheet where i want to look for "value1" to "value10" in columns I,
K, M,...
|
November 27th, 2009 06:02 PM
by QChris
|
3 |
114 |
|
|
Text Box with conditional formula by
Keyrookie[_30_]
Hey all,
Is there a way to conditionally format a text box? I have a calendar
that has text boxes associated with the cells and I want the text boxes
to...
|
November 27th, 2009 04:40 PM
by MRT
|
4 |
150 |
|
|
|
November 27th, 2009 03:25 PM
by dmkAlex
|
0 |
98 |
|
|
Conditional Formatting with Time by
Colin[_12_]
In one row I have 24 cells, each cell representing 1 hour. I would like a
cell to change color, say from white to yellow, during the hour it
represents on...
|
|
6 |
99 |