|
|
SAMPLE EXCEL DATA by
EricB
How do I sample data in a EXCEL spreadsheet? Say I have 50.000 records and I
want to sample say 0.1% or 50, what function do I use?
|
|
2 |
170 |
|
|
Format a dollar amount to text by
Jordan
Is there a way to take $10.56 and format it to read Ten dollars and 56 cents.
Thanks in advance for your help.
Jordan
|
|
4 |
282 |
|
|
negative value by
Radhakant Panigrahi
Hi,
I have below data with me, i have 4 columns where the "no of days" for
Employee ID (under a particular manager ID) is coming with -ve value as well
as...
|
April 30th, 2010 03:08 PM
by JLatham
|
6 |
175 |
|
|
|
|
5 |
197 |
|
|
|
|
2 |
209 |
|
|
IF formula help by
Mark D
Hi Again everyone.
Ok another problem I am now having.
I have the following formula in column H
=IF(ISNA(VLOOKUP(TRIM(A135),'Current running April...
|
|
2 |
166 |
|
|
VLOOKUP help (possible format issue) by
Mark D
Morning everyone.
I have a simple VLOOKUP calculation which is causing me problems.
=VLOOKUP(A23,'Current running April 2010'!$A$1:$Q$620,1,FALSE)
A23 =...
|
April 30th, 2010 12:50 PM
by Mark D
|
6 |
177 |
|
|
|
|
1 |
174 |
|
|
search excel for overpopulated cells by
darrick
i suspect my excel sheet is running slow due to one or more cells being
overpopulated. how do i search for cells with too many characters?
|
|
1 |
135 |
|
|
Help with lookup by
CW
Hi
I need to automatically populate a colum in a table with values from a
separate sheet.
e.g. in table 1, I have column headings:
Date; Type; Value 1......
|
April 30th, 2010 11:31 AM
by Eduardo
|
3 |
169 |
|
|
Dynamic sheet reference in Name formula by
Raj[_4_]
Hi,
The name "CurrentMonth" is defined using the following formula:
=OFFSET('Apr-10'!$H$5,0,0,COUNTA('Apr-10'!$H$5:$H$500),20)
The workbook has 12 sheets...
|
|
1 |
238 |
|
|
|
|
1 |
207 |
|
|
Average If... by
Nadine
I have a column of invoice numbers and multiple rows of data pertaining to
each one. So one invoice number could have 10 rows of data pertaining to it
so...
( 1 2)
|
|
12 |
248 |
|
|
protection error by
Selen
I have a problem with protection tool in excel. I set protection to
worksheet, but it had not applied to whole sheet. Some parts can still be
editing. Why...
|
|
2 |
138 |
|
|
adding time in a work schedule by
Chris
adding time (30 minute lunch) to a time value (6 hours) that is calculated
from two cells that contain starting time & ending time EX 6:30am-3:00pm
--
Chris
|
|
5 |
206 |
|
|
Vlookup return 2nd match by
MarkinArk
I have a quick question for you seasoned Excel gurus... I use Excel to track
win/loss streaks across several major league baseball teams. I then...
|
|
2 |
144 |
|
|
Average IF Function by
SandiVaughn
How can you test a range of cells to be greater than or less than another
cell using the average if function?
Ex: =AVERAGEIFS(A1:A4,A1:A4,"A6",A1:A4,"A7") ...
|
|
3 |
150 |
|
|
|
|
1 |
180 |
|
|
Counting Results of Formulas by
jgupte
I have a column in a spreadsheet that contains the result of a a lookup
function (refering to values in another spreadsheet) and displays a blank
field if...
|
|
1 |
183 |
|
|
|
|
6 |
141 |