# Archive by month October

## setting one worksheet cell range reference to another worksheet

I want to set one worksheet cell range reference to another worksheet using aspose.cells.For example i have two worksheet(wrk1 and wr2). I have some data on …

## Replace text, keep format

I have a spreadsheet containing 184 cells that I want to change on a weekly basis, when using the Replace function I lose the formatting of the text (all ends …

## Working with Values from Combo Box / Drop Downs

I am doing a budget planner where the user selects from a dropdown list the frequency of outgoing.  So say a gas needs to be paid every 2 months the user …

## Summing and saving time in a 24hr updating table.

Hi Everyone, I am making a spreadsheet and need help with summing time. I have daily values that change, monthly totals(which need to reset at the end of the …

## Sum If, If Two Numbers Equal a Specified Total

Hello, I hope you can help me with the following problem I am encountering. I have around 2000 rows with a set of 8 different numbers in each row. For …

## returning the colum name or heading of a minimum number

I have a row of numbers. I can use the MIN formula to tell me which is the minimum number but how do I get the formula to tell me which column the minimum …

## How to get a sum from 2 drop downs

I have set up a sheet and am having trouble. I have two drop down boxs which i set up using Data_Validation. When choosing from these i would like a 3rd …

## How to Sum a Range of Cells by Background Colour

Just recently I was asked if it was possible to sum a range of cells by their cell colour, rather than counting the number of cells with a matching colour. …

## How to Return Absolute Value of a Number in Excel

To return an absolute value of a number in Excel requires the use of the ABS Function.  An absolute value of a number is a the number without its sign, for …