Description:
Microsoft Office Excel newsgroup.
|
|
|
if and replace function?
|
| |
Hello I need help
I have names on my left and depending on the name I need to remove a space
Original data Answer
John, Repp John,Repp
Jay, Thorp Jay, Thorp
Jana, Washington Jana,Washington
So just depending on the name some need the space after the "," trim and some dont I have a total of about 40 names only about 6 dont need the space after the coma.... more »
|
|
|
Advanced Drop-down Menu
|
| |
I am trying to incorporate data from another sheet from the same file
into a drop-down choice on a menu constructed on the last page of the
file. I am using Excel 2007 btw.
I'm looking to have 3 different choices.
The file is DCF financial model projecting future cash-flows of a
company. The three choices will be:... more »
|
|
|
Varying cell ranges in formulas according to number of cells with certain value
|
| |
Hi all, I've been trying all morning to figure out a complex problem,
and I was hoping the good people here would be able to help.
So I have a spreadsheet with a list of companies, list of users within
those companies, and the status of those users(Active/Inactive/Deleted) .
I'm trying to determine the company-level status based on how the... more »
|
|
|
Automatically populate value of cell dependent on adajecent cell
|
| |
I'm not sure if I need a formula or a script for this, I've looked at
almost every formula in excel and I can't figure it out! Here's what
I'm trying to do:
In cells E3:E29 I have a drop down menu with a list of services. Depending on what the selection is in those cells, I would like the next... more »
|
|
|
Formula to add two spaces into a number stored as text
|
| |
Hello. I'm trying to do as the title says. The numbers must be arranged "0000 000 0000" and I'm trying to get that format applied to all the numbers in a column. The only problem is there are about 3000 numbers in that column so I can't do it manually. From searching around I've found the following formula =CONCATENATE(LEFT(H2,4)," ",RIGHT(H2,3))... more »
|
|
|
Generate series according to range and increment
|
| |
I am working with a two page workbook. On page one I have upper and
lower values of a range (example 0.0 to 5.0, or 0 to 100) and an
increment value (example 0.2 or 5). On page two I would like a column to
automatically fill with the series of values within the range according
to the increment value.... more »
|
|
|
Dynamic Ranges Adding Extra Row
|
| |
I'm trying to set up dynamic ranges (with mixed text/numeric data) using
the following base formula: =OFFSET($A$1,0,0,COUNTA($A:$A) ,1)
I have a header in the first row, so I want to start my range an A2.
When I change the first reference to $A$2; however, the range goes one
more row than it needs to. I've also tried to set the row offset to 1... more »
|
|
|
CONDITIONAL FORMATTING IN EXCEL 2010
|
| |
Sorry, this is obviously a really simply one, but the help comments are not making sense to me!
I wish to format A1 (background colour) when its value is higher than B1.
As in:-
A1 = 3.3% B1 = 2.8% so cell A1 background colour will change.
Thanks for the help!
Malcolm..
|
|
|
Text Dates/times to d:hh:mm:ss
|
| |
I have a problem that if able to use software that I am more accustom
to, like MatLab, I would be able to fix fairly easily. Unfortunately I
am only able to use Excel for this and I am still learning the language
and capabilities of Excel. I have a text field that is representative
of outage time that is filled with items like this: 1day 9hrs 35mins... more »
|
|
|
Comparing two lists
|
| |
Hello,
I have to compare two list and no vlookup does not work on this:
On list 1, I have the names of people and cities that they visited.
Eg. James New York
Dallas
Houston
Seattle
Mary Phoenix
San Francisco
Austin... more »
|
|
|
