Thread: Start Time & End Time

Good luck. Gord On Sat, 12 Dec 2009 16:04:01 -0800, Brickman > wrote: >Thank you, now give me about a week to figure this out! LOL > >"Gord Dibben" wrote: > >> Copy/paste this UDF to a general module in your workbook. >> >> Function PrevSheet(rg As Range) >> n = Application.Caller.Parent.Index >> If n = 1 Then...

Try one of these... Array entered** : =MAX(IF(A2:A6=541,D2 6)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. Format as Date >The table has about 3200 rows If you have 1000's of rows of data and there are duplicate codes *and* the data is sorted so that all duplicate codes are grouped together this longer formula...

This is what i have & it works it is high lighting B cells column now i want to high light AH cells column at the same time & from there i need to do rows 43 to 74 ,80 to 111,117 to 148,154 to 185,191 to 222, 228 to 259 also in the same manner also B & AH columns have a conditional colour format red green or yellow when these colours are in place it will not high light i believe if you or someone can make this happen...

1) Your First Step is Ok that is Filtering the column B - selecting only 9 (P1 & P3 was being sortlisted in this case) 2) Don’t copy the P1 & P3 from A COLUMN Cell & paste it in C COLUMN when it is in Filter. Do like this. Place the cursor in C COLUMN that is where the FIRST 9 is present. Now press the EQUAL Key (=) and refer it in the A Column P1 cell and press enter. Now copy the cell where you have applied the...

Have you tried =M5=MIN(IF($M5:$R5<>0,$M5:$R5)) best wishes -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "Marsh" > wrote in message ... > Works well, except it is formatting null cells. Those must not be > formatted. > If m16 is 25, N16 is empty and R16 is 11, cell R16 should be the one > formatted. > > "Luke M" wrote:...

Hi, not quiet sure what you need, did you try to select the range, copy, paste special, transpose "urlocaljeweler" wrote: > I am using Excel 2007. > > I have 5 columns as illustrated below - (Table Description has no rows yet) > > CTwt. Size Metal Jewelers cost Table Description > > 5 10 Tungsten 31 > 4 10.5 Tungsten 35 > 2 11 Tungsten 50 > 10 11.5...

You may want to take a look at Chip Pearson's rowliner utility. http://www.cpearson.com/excel/RowLiner.htm Mike wrote: > > I have columns from A1 to A300 TO CP1 TO CP300 if I click on a particulr cell > on any row is it possible to high light that whole row if there is a way > please tell me how!!! -- Dave Peterson

Thought that was a marvellous, super response. My hunch is that your Sub IntoOneCell() does exactly what OP wanted, albeit s/he has yet to reply. Thanks for sharing your subs with us!

> It's nice and short but depends on regional date settings. My solution > works with any setting. > Regards, > Stefi Stefi, Since the month is a 3 letter string, and the day is the 15th (and there is no 15th month), it should work with any regional date settings. My Excel handles 7 Aug 2007 the same as Aug 7, 2007 HTH, Bernie MS Excel MVP

Ah. So, we first need to determine what the max price is within your initial criteria, and then return the letter from column F that corresponds to a match with that highest price and a match of your initial criteria. You should be able to use this array** formula =INDEX(F:F,MAX(IF((A31:A47=A1)*(B31:B47=B1)*(E31:E 47=MAX(IF((A31:A47=A1)*(B31:B47=B1),E31:E47))),ROW (F31:F47)))) **Note that array formulas must be confirmed using...