|
|
Need formula creation by
Soth
Hi
I need help with formula creation. I'd like to look and find number in
column A and B for duplicate numbers, then show its duplicate value or number
in...
|
|
1 |
100 |
|
|
Normalizing Excel data across rows by
Greenstorm
I have a large spreadsheet (96 by 100) in Excel 2007 of recorded electrical
data. Each row represents data taken from a single source, and each column...
|
|
2 |
127 |
|
|
VLookup multiple spreadsheets by
Riley[_2_]
I have a database with about 50 spreadsheets, each containing data on
different deals. I'm looking for the best way to pull data to a
master summary tab,...
|
|
1 |
113 |
|
|
|
May 13th, 2009 06:40 PM
by Damo
|
2 |
134 |
|
|
|
May 13th, 2009 06:26 PM
by FSt1
|
2 |
120 |
|
|
Sorting Dates in format "01/19/09" by
SCH
How do I set my Excel to Always sort dates in the following format by Year,
Month, and Day? My current setting sorts by Month, date, and then year.
For...
|
|
4 |
127 |
|
|
|
|
1 |
130 |
|
|
Formula for counting and dividing by
Preschool Mike[_2_]
Here's my example. Cells A1:H1 have + (plus sign: goal met) and - (minus
sign: goal not met) in them and some cells in the same row have nothing if
the goal...
|
|
1 |
105 |
|
|
How to use time in an IF formula by
kwalker4
Good morning.
I'm having trouble using time (minutes and seconds) in an IF formula. I'm
trying to assign a rating to four time thresholds. My rating and...
|
|
4 |
117 |
|
|
Lastrow by
Bishop
I'm familiar with this code to find the last row:
LastRow = .Range("A" & Rows.Count).End(xlUp).Row
But what if I need LastRow to be at a certain value? If I...
|
|
2 |
98 |
|
|
Keeping a text box on the worksheet by
Twin10
I've just recently been upgraded to Office 2007.... I am having trouble with
a worksheet that has a text box in it...... When I print the worksheet the
text...
|
May 13th, 2009 05:06 PM
by Twin10
|
0 |
153 |
|
|
Sort w/o header row - change default by
Niecee
Excel 2003 determines if there is a header row or not. Half the time i'ts
wrong.
My file will never have one so I'd like to change the default to "no...
|
May 13th, 2009 04:55 PM
by Niecee
|
0 |
119 |
|
|
Adding Data from Multiple Spreadsheets by
Belle
I have createda spreadsheet which includes separate workbooks with figures
for each month of the year, I have also created a workbook within this
spreadsheet...
|
|
2 |
96 |
|
|
Row height will not auto format by
gladfelterk
I am using Excel 2007, and opening a spreadsheet in an older version of
Excel. When I double click on the line between rows to auto format the row
to the...
|
|
0 |
91 |
|
|
If Month? by
RJJ
I am struggling with an If=Month formula. In its simplest form, A1:A12 is
January thru December. Cell C1 to show "If month (happens to be May of
course) than...
|
May 13th, 2009 04:12 PM
by RJJ
|
8 |
141 |
|
|
data return using multiple conditions by
Steven M.
I am trying to return the contents of a cell on a row which must meet
multiple criteria. I have 2 worksheets, one which contains the criteria, the
other...
|
|
4 |
164 |
|
|
|
|
4 |
121 |
|
|
Visit Calculation by
kashish
My data as below,
Place Jan Fab Mar Apr
A 1,2 3 11,12 3
B 5 2 3
C 30,31 2 5 5,2
C 1 2 10 15
B 3 17,25 24 24
A 17 20 9,10 5
|
|
2 |
112 |
|
|
|
May 13th, 2009 02:40 PM
by CLR
|
1 |
145 |
|
|
|
|
2 |
122 |