|
|
Auto Insert Data by
Kanmi
I have two worksheet on the same workbook called sheet1 and sheet2.
I want data entered on sheet1 to automatically show on sheet2.
Example. "Sheet1"
...
|
June 23rd, 2009 08:02 PM
by Eduardo
|
1 |
133 |
|
|
Vlookup and formatting correctly by
brett
This has more to do with formatting a text string, but how do i format a
column that already has data in it using "=TEXT(A1,"@")"? This is the only
way i...
|
|
4 |
116 |
|
|
|
|
4 |
128 |
|
|
specific data by
MFS
Hi all, I used an example to explain my problem
I have data (plant/car) in column A in sheet 1, I want to have specific data
in sheet2 (only car) without...
|
June 23rd, 2009 06:47 PM
by Eduardo
|
1 |
118 |
|
|
|
June 23rd, 2009 06:07 PM
by ckg
|
4 |
146 |
|
|
Seperate Names on Columns by
Kanmi
I have column that contain names both first and last name. I want to break
this to different column that will seperate First name on its own column and
last...
|
|
3 |
137 |
|
|
Selecting rows to another sheet by
Muskrat24
I have an excel sheet that has lists of categories and several selections for
each. I use a Filter to select only the rows with a "X" in column J. I want
the...
|
|
2 |
147 |
|
|
|
|
12 |
203 |
|
|
Need a Function by
Charlie
I need to retrieve a character value from a given position within a text
string, how would I do that?
For example, I want to pull the value of the 4th...
|
|
4 |
112 |
|
|
Lookup related question by
Craig
Hi
I have a 2 column table I want to use as a lookup table; one column showing
all the company's employee names (last then first in one cell but no middle...
|
|
1 |
97 |
|
|
conditional formatting gliche. by
mrogozinski
One of my conditional formatting rules is as follows:
If value of the cell is between 4.5 and 5.0 then format the cell "green".
The problem is the formula...
|
|
2 |
117 |
|
|
|
June 23rd, 2009 04:09 PM
by Mike H
|
4 |
116 |
|
|
|
June 23rd, 2009 04:06 PM
by Paul
|
11 |
221 |
|
|
IF ERROR Formula by
Denver
=IF(ISERROR(FORECAST(COLUMN(),$AF4:AH4,(COLUMN($AF1:AH1)))),"",FORECAST(COLUMN(),$AF4:AH4,(COLUMN($AF1:AH1))))
I have this formula in my worksheet but a...
|
June 23rd, 2009 04:00 PM
by Denver
|
3 |
122 |
|
|
Protected cells can't be grouped by
Cara
I have made a document full of macros and protected the cells to prevent
anyone writing over the formulae. I need to use the group function for some
of the...
|
|
1 |
110 |
|
|
Format a cell based on incremental numbers by
MurrayBarn
I have a workbook with multiple sheets. On one sheet, I have a cell where I
manually change the contents from 1 to 12 (corresponding to months of the
year)....
|
|
3 |
168 |
|
|
using autofilter data by
edward
Is it possible to get access to data appearing on the auto filter dropdown
lists which show at the top of the filtered range?
Would it be possible to control...
|
|
2 |
95 |
|
|
Adding 2weeks and rounding up to EOM by
Micki
I need to add 2 weeks to a date and round it up to the last day of the month.
G11: 6/15/2009
Add 2 weeks, but round to 6/30/2009
If I add 14 days to...
|
June 23rd, 2009 02:13 PM
by Micki
|
3 |
122 |
|
|
vlookup by
Mike
can vlookup be used to find multiple matches in a table on sheet 2 for a
single index number on sheet 1?
|
June 23rd, 2009 01:43 PM
by Mike
|
6 |
212 |
|
|
If question by
tss
I have three columns, A, B and C, I need a quick analysis / IF statement to
determine:
If A is between B and C,"A IS GOOD"
If A is below B, "INCREASE A"
If A...
|
|
4 |
121 |