Recent content by Simont485

1. Excel Conditional Formatting

ok now solved Use Exact instead of search!!!
2. Excel Conditional Formatting

I have a row of cells that contain numbers. A2 to A10 In the row below I have the conditional formatiing corresponding to the cells above. B2 to B10 I only want to format for the number 41. B2 CF is =search("41", A2) formatted to fill the cell in blue But other numbers conataining 4 and 1...
3. Excel Date Count

=IFNA(\$B\$2-LOOKUP(2,1/(\$C13:\$I13="x"),\$C\$2:\$I\$2),"") This does it!!!
4. Excel Date Count

I need to count the days between today date and a previous date based on another cell. See attachment..... Any question please ask.....
5. Excel Staff Rota

No rush...I think I have a solution....but need to check again!!
6. Excel Staff Rota

Another idea suggested to me is to have a list of staff available on a given date based on their shift and availability. Hopefully the attachment gives enough information. A bit like my last post but a lot more complex.
7. Excel The logic hurts my head

So been searching/asking on another forum. Have been shown this formula. =INDEX(\$B\$3:\$B\$12,MATCH(\$O\$3&"",INDEX(\$D\$3:\$D\$12&"",0),0)) It Indexes to column B and matches to column D but when the reference cell is blank it returns a result instead of N/A! Ie it searches for blanks! Anywayfurther...
8. Excel The logic hurts my head

Attached....I hope!
9. Excel The logic hurts my head

I have been trying to sort this but I have fallen at the first hurdle! I can use Index/match to list a name from column A dependent on the contents of column B. But I want to show a name from column A when column B is blank. Any ideas?
10. Excel The logic hurts my head

SO this rota that is used at work is a nightmare........I have been tasked in listing by date, staff who are available to cover shifts based on previous overtime count. I can't upload an attachment example??!! Attached a photo instead...hope it's Ok! I have been trying with index/match which...
11. Excel Is this possible??

For reference formula I used =vlookup(A1,sheet1A3:NK50,Columns(\$A\$3:A3)+1,False) So it does the look up but, as I have a large spreadsheet , instead of entering a column number I have used the Columns functions so that the column number increments when I drag/copy the formula across the...
12. Excel Is this possible??

Ok I have solved this.....Vlookup combined with Columns function to catch all data....seems to work!
13. Excel Is this possible??

On sheet 1 I have a staff rota that has about 50 names listed in column A and dates across row 1. (50*365 cells) on sheet 2 The dates will be across the top as per sheet one I would like to input a name in cell A3 and that persons rota for the year appears in row 3. and so on for each...