Group:  Microsoft Excel » microsoft.public.excel.worksheet.functions

Geek News

Threads Replies Last Post
1263 Pages: <<  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  47  48  49  50  >>  
Flagging a cell
Hi, I have two cells that I would like to use to flag one. I have a cell that would show if an appraisal was done inside a home or outside. My Cell title is "Apprsl I or E" and I have a list of properties that have an appraisal of I or E. The column next to it is the appraisal date. I would like to flag the appraisal date column cells if appraisal I is older than 6 months from today...
4 12/4/2008 10:04:01 PM
How do I vlookup
I've got 2 worksheet with about 25 pieces of data. I need to be able to identify when one of the pieces of data are not the same in each worksheet. I created concatonates in the first column of each (columns in each associated with account #, billing # and name). That's my join info. I want to be able to id those where the phone # on each are not the same. Would I do a vlookup? How do I ...
5 12/4/2008 8:34:48 PM
Auto-filter with Sum product?
I am trying to use sum product I believe for the following formula..... =(SUM(M3:M468)/SUM(F3:F468))/1440 I am trying to use auto-filter to give me the above answer for just the fields shown after filtering. Any ideas????...
3 12/4/2008 7:22:34 PM
Is it possible to display feet and inches in one cell ?
Microsoft Excell 2007 - I am trying to convert a number to feet and inches. As far as I can tell it will only show feet or inches but not both such as 1ft 5in....
5 12/4/2008 6:14:57 PM
IF Function .....
Very sorry - I have posted this in another groupd and have realised this is in fact the correct place to ask. I am currently using the IF function to display a score value based on age. I am currently using 2 cells with 2 seperate equations for boys (with age in C5): =IF($C$5=11,10.6,IF($C$5=12,12.8,IF($C$5=13,15,IF($C$5=14,17.2,IF($C $5=15,19.3,IF($C$5=16,20.1,IF($C$5=17,20.9,IF($C$5...
4 12/4/2008 5:56:33 PM
Flagging an outdated cell
Along the same lines as another thread I read earlier, I am trying to set up cells that will turn red or have a validation message pop up if the date in the cell is over 60 days old from today's date. I want it set up so when I open the spreadsheet, if the date in, let's say, cell K8 is 7/11/2008, that the cell should be red, or I have a message pop up when select the cell saying that th...
6 12/4/2008 5:39:59 PM
Percentage increase of one cell to another in Excel?
I am trying to find the percentage difference from one cell to another. Cell C1 is $89 and cell D1 is $99. What is the formula to find the percentage increase? -- Holly N...
5 12/4/2008 5:18:55 PM
training tracker
I am tracking training for my unit using an Excel sheet put out by the military (must use). The columns are each seperate training class and the rows are the individuals. Each class has a Shelf life (must be completed with in a certain date. That date<MOB=mobilization> is solid and does not change, all the other columns go off that cell) I have placed a conditional format on each co...
4 12/4/2008 5:14:38 PM
Find matching values
I regularly have to compare two spreadsheets of account names to find the matching values. Each spreadsheet has account names in one columns, but then other columns will have different info, which I have to merge together if there are matches. I usually line up the columns and then color one set red and them put them into the same worksheet and sort by name and scan visually for matches...
3 12/4/2008 4:57:01 PM
Transpose with Match ?
Hi, Was wondering if possible to use the Transpose function with another function. On Sheet 1, I have names in C3:C20, with data in each row of the names, from D3:AH20. What I want to do then, is on Sheet 2, B2, anyone of those names from Sheet 1 can be entered, then have the data from Sheet 1 on that row that matches the name entered, be transposed to F3:F33 on Sheet 2. So anytime the ...
5 12/4/2008 4:36:02 PM
Count multiple criteria
I'm trying to count how many times a combination of 2 criteria occur at the same time across a range that sits in another worksheet in the same workbook so I can summarise the amount of sales (not value) by month & year. I've spent ages looking at the advice on this so far and tried various suggestions involving the sumproduct, countif and IF functions. I can manage the countif and s...
8 12/4/2008 4:23:02 PM
Referencing Icon Sets
Cells A1:A1000 contains a conditional formating Icon Set (red x, !, and check mark) I want Cells B1:B1000 to enter automatically insert text based on the Icon in the A column. Examples: A1 contains a red x icon....i want B1 to put automatically put the text warning. Any suggestions? ...
4 12/4/2008 3:07:01 PM
VLOOKUP with a blank cell
I am trying to do a vlookup that looks for the value in the cells in column A in my table. However, some of the cells in column A are blank. My lookup table has a blank in the first column and a code value to be returned in the 4th column. When I try to do the lookup and it encounters a blank cell, I get a #N/A result instead of the code. Here is the formula I have now. =VLOOKUP(A13,$F$...
6 12/4/2008 2:43:03 PM
Normal distribution
Hi, good morning, I have a list of values and intend to trace a graph of normal distribution. How I can make using excel 2007? Supose that this is the list: column A 91,00 88,00 79,00 78,80 77,00 75,30 74,00 72,40 71,00 68,00 66,00 65,50 65,40 62,30 61,00 59,00 56,00 55,90 55,00 Thanks in advance!...
3 12/4/2008 2:36:01 PM
vlookup and lookup
I'm using a simple 2 column table with either vlookup or lookup function and some of the return values are the row above. I realize if it doesn't have an exact match it will return the next largest value that is less so I used the Round function to make sure there would be exact matches. What am I missing? -- Ruthie...
13 12/4/2008 2:17:05 PM
Sum a NULL cell
Hi, I've got a complete mind block on how to get this right! I have 5 values in cells a1:a5 - 1, 2, NULL, 4, and 5. When I try and sum all 5 cells I get #value! Can I sum all five cells (12) even if there is a NULL in a cell please? Thanks in advance, AW...
7 12/4/2008 2:04:56 PM
Expand Selection in Auto filter
Hi, My file has columns till DR. I have a spilt in the sheet at AP13.I am using 'Sort ascending' from the auto filter at CQ to sort the my file but my sort selection is not expanding to entire columns. Column A-AP are not getting sorted ascending, and now i have data all jumbled up! Thanks for your help. ...
8 12/4/2008 2:00:20 PM
Formula for empty cell
I am trying to put a validation into a cell that would refer to two other cells. I want to make it so if I try to type text into B9 cell, I either have to put an X in cell A10 or A13 first. I sure there's a way to do this, but I can't figure it out. Any ideas?...
3 12/4/2008 1:45:27 PM
More Conditional Formatting
I posted a thread earlier: "If i have a date in column A and have a formula that calculates 90 days from that date to Column B and I want to add conditional formatting to Column B that flags 120, 90, and 60 days from the column B date how would I go about doing that?" I receved the following (which works great): =AND($B1>TODAY(),$B1<=TODAY()+60) <- Flags Red =AND($B1>TO...
2 12/4/2008 1:26:01 PM
Conditional Formatting
If i have a date in column A and have a formula that calculates 90 days from that date to Column B and I want to add conditional formatting to Column B that flags 120, 90, and 60 days from the column B date how would I go about doing that?...
4 12/4/2008 12:13:01 PM
countifs on earlier version of excel
Hello, I have been working on 2007 excel and used the below formula: =COUNTIFS(JAN!G:G,B14,JAN!B:B,C2) I have just noticed upon saving that this will not work on earlier versions of excel. How do I need to change the formula please to make it compatible? Thanks Aaron ...
3 12/4/2008 11:34:01 AM
HLOOKUP Help
Sure this must be quite easy, but I'm trying to sum the number of training days people have planned, booked or completed. A simplified version of the sheet looks like this: DAVE B B P P C C FRED B C C DAYS for 1 2 1 2 3 1.5 course excel word ppoint access etc...
2 12/4/2008 10:47:52 AM
vat formula
Can anyone tell me what formula I can use to calculate the cost before vat based on the rate here in the UK before and after 1 December? I know roughly what I want but don't know how to correctly put this into a formula. E.g. I have the date in column J2 e.g. 30/11/2008 The total in column K2 for example £100 In column L2 I will have a formula something like this: IF date in column J2 ...
3 12/4/2008 10:40:08 AM
Lookup Value in Table
Excel 2007 I have data that looks like the following A B C Row 1 INTC MSFT IBM Row 2 $1500 $2400 $1850 I need to write a formula that finds the maximum value in row 2, and returns the corresponding value in row 1. The MAX() function will return $2400, but I can't figure out how to get my formula to return "MSFT" which is what I really need. Any help will be greatly appreciate...
9 12/4/2008 6:14:01 PM
When I freeze rows I want it to scroll 1 at a time, not 3 at a tim
...
3 12/4/2008 9:39:01 PM
1263 Pages: <<  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  47  48  49  50  >>  

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net