|
|
Vlookup-Doesn't return values under 1 by
Carolina
I have Sheet 2 with 6 columns, one of them with ascending numbers on column A
0-8.99 with two decimals. The other 5 columns are payouts per title and if...
|
|
2 |
209 |
|
|
Delete Rows using If and Wildcard by
Max2073
I'm trying to delete all rows that DO NOT contain the text "ENTER" in column
F.
I have tried a few different methods based upon research from this site, but...
|
|
2 |
179 |
|
|
|
|
2 |
176 |
|
|
Delete Rows using Wildcard by
Max2073
I'm trying to make delete all rows that DO NOT contain the text "Enter" in
column F. I need to use a wildcard - as a number of cells contain additional...
|
|
2 |
165 |
|
|
Yearly sum by
jam[_3_]
Any help?
I have a column that I want the monthly sum and then the yearly sum,
any way to make it easier?
A B
1 Jan
2 1 100
3 2 150
4 3 260
5 31 100
6 Sum 610
|
|
3 |
233 |
|
|
autopopulate based on a cell value by
Art
I created a spreadsheet in Excel 2007 for instructors to use to prepare
multple choice questions for an exam. Each row represents a different
questions. So,...
|
March 16th, 2010 02:34 PM
by Art
|
2 |
246 |
|
|
|
|
1 |
155 |
|
|
List top five by
Dazed&Confused
Hi there,
I've searched this site looking for an answer for this but no luck
What I have is imported list of invoices thousands of rows long with about
450...
|
|
4 |
222 |
|
|
Vlookup-Doesn't return values under 1 by
Carolina
I have Sheet 2 with 6 columns, one of them with ascending numbers on column A
0-8.99 with two decimals. The other 5 columns are payouts per title and if...
|
|
1 |
138 |
|
|
Help to create a formulae by
FredDave
I have 5 sheets, Heath, Gary, John and Fred.
They go to their sheet
Heading: Date Question1 Question2 Question3
They ent 3/3 5 6...
|
|
1 |
130 |
|
|
|
March 16th, 2010 01:07 PM
by Max
|
3 |
138 |
|
|
|
|
1 |
128 |
|
|
|
|
1 |
183 |
|
|
Macro Help by
Curtis[_6_]
I am very new to Macro's but am hoping you can simplify your response
I have a sheet that contains certain data types in specific columns
For example...
|
|
1 |
127 |
|
|
|
|
1 |
123 |
|
|
Help on percentages greater than 100 by
cil
Thanks in advance for your assistance.
I have a fairly larger list of numbers that needs to be divided to get a
percntage. Due to restrictions, accesses etc...
|
|
3 |
121 |
|
|
|
|
12 |
282 |
|
|
rename worksheet tabs by
fix me
Hello,
Maybe you guys can help me. Is there a way rename the worksheet tabs
in an Excel file that I've already created?
Example...
I've already created a...
|
|
2 |
134 |
|
|
|
|
0 |
136 |
|
|
|
March 15th, 2010 10:59 PM
by cherman
|
2 |
157 |