I have data like this
12 23 35 44
45 6 3 9
I would like the show them:
highest one filling red
lowest one filling green
2nd highest one filling yellow
3nd highest one filling blue
is that possible? The...
Trying to colour a cell on one sheet if the reference number entered already appears on another sheet.
Googled various options as it keeps filling the cell above instead...
The rule I tried is
=MATCH($A2,'DNA No Support & WD Pre Census'!A:A,0)
First of all, thank you very much for such a site and it has been so helpful for me.
Problem: so I'm doing an almost daily task which I couldn't do it by macros, I'll explain it by an example;
For example, let's say that here I have the following table in Sheet1:
Order No Color S M L...
I want an order straight down for automatically filling in excel. Like this:
'=INDEX(Sheet2!$1:$1,(COLUMNS($A:A)-1)*2+1) &", "& INDEX(Sheet2!$2:$2,COLUMNS($A:A)*2)'
'=INDEX(Sheet2!$2:$2,(COLUMNS($A:A)-1)*2+1) &", "& INDEX(Sheet2!$2:$2,COLUMNS($A:A)*2)'...
Can't seem to work out the correct method for this.
I want to select and then Autofill a set of Formulas but no matter what I try I keep getting an Error :(
This is what I started with that I thought would work;
Range(Cells(j, "E"), Cells(j, "G")).Select
I would like to hide some row that doesn't have any value for each cell within a row,
here below sample table :
Items / Stocks
This is embarrassing...
I have a modified ridiculously large spreadsheet that someone else built pulling data from all sorts of weird locations. i did not save a backup copy.... now the file will not open and get's stuck at the filling cells part of opening. i wonder if there is a way for...
I have a header row in a single field in column 1 in the following format:
Scenario: Actual Year: 2018 Period: Jan Value: <(Entity)>
Below this I have my normal data columns.
How can I unpivot this single top header field so that I have just the Year (2018) filling down one column and the...
I'm having some real trouble with what is the best way to do this:
In column J I want to return the value in column C based upon criteria in B and D.
This is the formula I have been using in J1:
=(IF(D:D = "filling",VLOOKUP(I4,B:D,2,0),""))
<colgroup><col width="64" span="9"...
Have a good day everyone!
Problem : Row(s)/cell(s) automatically will be locked after filling colors
I know this may sounds like a broken record , but i can't find previous thread about my excel problem. Can someone help me please..thank you in advance.
I am making a payroll reporting worksheet and want the top of each column to have "WE" and the date of every other Friday in the cell. i.e.
My problem is how can do I get the date to fill every other week when I drag it out? I have...
Does anyone have a solution on how to fill a value upwards until a new value appears? (and then repeating the procedure after the new value)
I know this can be done downwards with "find -> blanks, entering a formula and then ctrl+enter" but I cant figure out how to make it work upwards...