Hello, I got help in a previous request on highlighting text from a conditional format issue and it works great. I do have one additional question however. I...

I am trying to set up a formula to allow five variables to be aggregated (or not)when they are switched on or...

How can I set up a count down clock in Excell that recalculates a formula on a repeating basis, not just when the workbook opens or the spreadsheet is...

I am trying to set up a formula to allow five variables to be aggregated (or not)when they are switched on or...

I have a workbook which contains 300 records from which I wand to be able to randomly select 50 records. Each record has a geographical area attribute (e.g....

The following example is from Microsoft documentation. Enter the following information in the quoted cells. A2 Sales A3 12/08/2008 A4 A5 19 A6 22.24 A7...

Hi, I have a big problem and I just dont know which route to take. I have a product list for which i have set up data validation so that the user can select...

I have a range of accounts: 022.9700 000.4500 001.9600 r100.R9500 For those with no "r" I want to use a function of:

How do I put this typ of equation into an excel spreadsheet. A6(variable)+____ =65 (A6+B6=$C$6) I need to set up a spread sheet so when I put a number in...

Is there a way to update a date cell with a new date after the date in the cell has passed? ie. I have 7/1/2009 in a cell. After 7/1/2009 has passed, I want...

hello I have this formula =IF(L43=0,0,IF(L43=1,1,IF(OR(L43=7,L43=8),8,IF(L43=9,13,IF(L43=5,5,IF(L43=2,2,IF(L43=6,6,))))))) and I want to add that when...

MikeS wrote... I've created an XLA file that I plan on sharing with co-workers (it will be on the network) I have put some Sub macro...

I need a formula which will return information from a cell which is not part of the formula. Confused? I know I am. Excerpt from table which is much, much...

ali wrote: Hi folks, i have a range of data column a: staff payroll number column b: first date of absence column c last date of absence ...

I have two columns of numbers, and I want to calculate the slope of the regression line for the data from the current row to the bottom of the table. I...

MikeS wrote: I've created an XLA file that I plan on sharing with co-workers (it will be on the network) I have put some Sub macro code in the XLA and...

Hi, I wana calculate the difference between two times and then the result should be multiply with specific number, which user defines manually. For...

Gareth.Evans wrote: Hi all, I have a sheet which contains detials of invoices. I wish to consolidate the infomation of the invoices and sum the ...

Trying to create a text string with ". The best I can do is generate a single-quote and then find/replace the single for a double-quote. I also tried using...

Wayne wrote: Can I assign a user defined function to a cell? I have the function "=AUST_RWCFR_MAText" assigned to a textbox and it works well. However ...