Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
microsoft . public . excel . worksheet . functions
This is a Usenet group - learn more
Find or start a Google Group about functions.
Group info
Language: English
Group categories: Not categorized
More group info »
Active older topics
2 new of 2 - May 19
10 new of 10 - May 16
21 new of 21 - May 13
14 new of 14 - May 13
2 new of 2 - May 12
2 new of 2 - May 9
5 new of 5 - May 9
3 new of 3 - May 8
1 new of 1 - May 8
12 new of 12 - May 8
Discussions
View:  Topic list, Topic summary Topics 1 - 10 of 148792  Older »
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 »
By jc9972...@yahoo.com  - May 22 - 6 new of 6 messages    

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 »
By Jaz3385  - May 21 - 3 new of 3 messages    

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 »
By Dranoeler  - May 20 - 2 new of 2 messages    

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 »
By Crystal84  - May 17 - 4 new of 4 messages    

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 »
By mich...@riversway.net  - May 17 - 5 new of 5 messages    

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 »
By primeride2k  - May 16 - 6 new of 6 messages    

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 »
By KeriM  - May 16 - 3 new of 3 messages    

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..
By Malcolm Austin  - May 16 - 2 new of 2 messages    

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 »
By Bigskenney  - May 15 - 5 new of 5 messages    

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 »
By RB  - May 13 - 1 new of 1 message    

1 - 10 of 148792   « Newer | Older »

XML