| Thread | Last Post | Replies |
|
| If/Then formatting | 09 Mar 2008 18:50 GMT | 2 |
Novice here I would like to highlight/color a cell if the number of that cell exceeds the number of the cell next to it. The cell I would like to color already has a formula for adding in it.
|
| MERGED CELLS | 09 Mar 2008 17:55 GMT | 4 |
Dear sir, I have an sheet which has 15000 data. In which some data is same and i have to merged the same into one. Is any way to find the same data because it take many hours to find one by
|
| finding index | 09 Mar 2008 16:59 GMT | 1 |
i need to find out the index of the maximum value in a specific column, how do i manage that? thanks
|
| Painting equal cells | 09 Mar 2008 14:36 GMT | 2 |
I have to columns, side by side full with 248 rows of data. How can I paint, using conditional formatting, the cells with equal data? Thanks, Amnon
|
| subtracting time going backwards past midnight? | 09 Mar 2008 14:21 GMT | 3 |
I am trying to track time going backwards. In other words I am backing into a start time. I am having problems when I cross midnight going backwards.
|
| sum of cells that correspond to non empty cells | 09 Mar 2008 14:04 GMT | 4 |
if i have two columns and i want to sum the values in each cell in each column that correspond to a nonempty cell in the other column what should i do?
|
| how to move data from a cell to another one without using any macr | 09 Mar 2008 13:07 GMT | 2 |
i used If Function to set a criterion for Excel to perform a task if the returned value is TRUE. of course it did it. now I'd like to know how i can show the results in another cell if the returned value of If Function is FALSE. It can be done by defining a Macro but I like not ...
|
| How to UN-hide column A? | 09 Mar 2008 12:04 GMT | 3 |
I need to UN-hide column A: I had to Hide column A, and now I can't UN-hide it. I tried the normal way of clicking on the top of column B and moving the highlight left to supposedly include column A, but without success.
|
| paste data over hidden cells that are filtered | 09 Mar 2008 02:11 GMT | 1 |
i want to paste data to a filtered sheet that has rows hidden and for it to ignore the hidden rows . i have excel 2007. please advise the simplest way
|
| enter ascending numbers to excel invoice template | 09 Mar 2008 02:10 GMT | 3 |
Is it possible to create an excel template and have that template self-generate a new Invoice number each time it is opened?
|
| Meeting Minutes in 2 languages | 09 Mar 2008 00:58 GMT | 6 |
Hi! I have an Excel template to write down meeting minutes. I'd like to add the possibility for people to choose whether to read the minute in English or Spanish in the same sheet, not one sheet for English and another for Spanish.
|
| what function would do this? | 09 Mar 2008 00:08 GMT | 3 |
Help please... I have a single column of data that is over 256 rows. They are dollar amounts and I am looking for every possible combination of the numbers that equal a specific dollar amount. It could be that is only a sum of two
|
| Send contents to another page | 08 Mar 2008 23:40 GMT | 11 |
I'm trying to send the contents to another sheet without having to copy/paste each time. Whenever something is entered into sheet 1 that row is sent to sheet 2. I quess in the worksheet change event? Thanks in advance!!
|
| Painting blank cells | 08 Mar 2008 23:39 GMT | 4 |
How can I use Conditional format to paint all empty cells on a certain range (say A1:D24) with yellow color? Thanks, Amnon
|
| Send to another sheet row by row | 08 Mar 2008 22:02 GMT | 3 |
Say I put data in (sheet1 columnA cell a1) and I put data in (sheet1 columnB cell b1). I want to be able to send those results to sheet2 starting at row1 and each time something is added to sheet1 those results are sent to sheet2 to the next row and so on. Thanks in advance
|