Description:
Microsoft Office Excel newsgroup.
|
|
|
Summaries based on criteria
|
| |
I has 2 sheets, one with all my data and a second which summaries it.
In my data sheet I have the following columns
Date Name Status Price
01/01/11 Mr Smith A 10.00
01/02/12 Mr Jones A 15.00
01/03/12 Mr Tims B 12.00... more »
|
|
|
Expand Data Structure to One Record per Time Period
|
| |
I have a giant spreadsheet that I inherited, and I would like to change the data structure. I would like to have each record (row) correspond to one date; currently it is set up with a beginning and end time period. I think an example makes clear what I’m hoping to do. Does anyone have a suggestion as to a relatively efficient way to go about this? Any ideas would be much appreciated.—Dan... more »
|
|
|
Dashboard & Sheet switching
|
| |
I am designing a dashboard / workbook for our projects which has different sheets for different elements of each project (i.e. specification, expenses etc). There will be one workbook for each project.
The problem I'm having is deciding on the best way to deal with the scenario of needing different variations of the workbook depending on what type of... more »
|
|
|
help pence to pounds with formula
|
| |
I am using =(B3*D3)+(E3*C3)/100
the part /100 I thought would convert to £s
but is giving £1982 instead of £19.82
can you please correct.
thank you
|
|
|
Conditional formatting based on formula cell
|
| |
I have a cell which returns a value from elsewhere (its a vlookup formula) with an iserror function attached so that if there is no result the cell appears blank (but its not as it contains the formula). next to the cell I have a cell with conditional formatting which changes bases on whether the... more »
|
|
|
Remove certain characters from a text string
|
| |
I have a cell which groups together text into 1 string as follows:-
Name Address Postcode
Cell formula is A1&", "&B1&", "&C1
This returns Name, Address, Postcode
However sometime the postcode isnt known or relevant so we insert N/A in the postcode column. When this happens the text string shows.... , N/A. I want... more »
|
|
|
Macro to Create Hundreds of Graphs
|
| |
Hi Everyone,
I'm struggling with a macro to automatically create about 200 line graphs.
There are a variable number of datapoints in each graph. The data are all in
one column separated by blank lines, like:
123
456
789
887
762
1
2
3
55
44
88
447
I'm new to macros and have tried recording a macro to see the code. The... more »
|
|
|
Advanced conditional formatting
|
| |
Hi I have a value in Cell E4 and a date in F4. I want to conditionaly format E4 if the date in F4 is less than NOW(); with any formating that is available IE Font colour or background colour.
TIA
Desmond
|
|
|
Find total based on a partial match
|
| |
I'm trying to find the total time on all projects with identical initial code.
For example in column C, I have:
SHOG1001
SHOG1002
SHOG1003
ABCD1234
BCDE1234
BBBB3333
...
I'd like to find the total time spent (each time is in F column) on projects staring with SHOG. In the example above, it would the first 3.... more »
|
|
|
find and replace formula text?
|
| |
Sometime people copy and paste item and push the cell down. Then my formula would stop working because one of the end cell location would be different from the others. Is there a way I can find and replace formula text of all the cells in a document?
For example:
=SUMPRODUCT(--($A$3:$A$4841>=A 422),--($A$3:$A$4841<=B422),-- ($B$3:$B$4841=D423),($E$3:$E$4 800))... more »
|
|
|
