Search results

It should be closet to the cell value. I have attached another file please check. There is an error uploading the file.

Please find the xls file

Dear friends, I have a range of price value (stock), where i am using two conditional formatting "between & inbetween" option to highlight a column range. Now i want to highlight the close price (single cell) on the same range as the third conditional formatting. how do i proceed for the same...

Sorry please check this file pucha

Yes, Thank you. Thank you once again for keeping those files. But as those files were created by you somewhere in dec 9, 2012. Later I had modified it as per my use. Now the modified file is no longer with me. Will you please check the file I am uploading for your reference and the output I...

Thanks Narayank991, I am trying to load a workbook with data as the original has gone with my crashed hard disk. pucha

Hi Narayank991, Thank you for the above excel file "Time-Division.xls", which I was using regularly, but unfortunately last week I had a difficulty with my hard disk, It crashed and had to replace with a new one. I missed all my files their. Will you please help me to send the excel file once...

THANK YOU p45cal, I just want this. Many many Thanks Pucha

Here I am loading a workbook for reference. Thanks Pucha

I have 7/8 tables in sheet 1. First i want to highlight the the rows with current time running (now). Then want to collect all the data (highlighted) from each table to a new table. Table-1 cell1/cell2/cell3 10:25:53/11:26:45/A(event) 11:26:45/12:25:35/B(event) ...

SUPERB!! MANY MANY THANKS FOR YOUR EFFORT. SO NICE OF YOU THANKS REGARDS PUCHA

Hi Thanks I have change manually the date format to mm/dd/yyyy & copied the formula to I2 But it showing "#NAME?" in that cell. Please Revised Regards Pucha

Hi Yes it should be of same format. computer format - mm/dd/yyyy Thanks Regards

Any solution!!

Dear SirJB7 Due to internet disturbances I could not reply. Thanks its working. But till not getting the output as I required, may be due to incomplete data I have provided in my first post. So please requested to check that...

Hi Both array & normal not working. Normal formula is giving value "0" Thanks pucha

Again sorry,,, The cell will be "I2" or the next cell "j2" Thanks

Sorry for this... I want to get the output data in sheet named "dailymcx", "H2". Match should perform like this... "Ticker & Date" of sheet "dailymcx" should match "Ticker & date" of sheet "mcxall" and the output in sheet "dailymcx", "h2" Sorry for Inconvenient, Regards

Dear friends Thanks for the earlier problems that you all help me to solved. I want to pull data from another sheet by matching the date. Sheet 1, named as "dailymcx" & Sheet 2, named as "mcxall". data in "dailymcx" ALUMINI-I,08/01/2013,108.60,109.35,108.30,109.10,4.82,3672.00...

Hi Narayank991, Thank you once again. The excel file is working perfectly. Brilliant. "Sorry to reply late. I went for a vacation as my daughter's exam was over." Regards pucha

Hi Narayank991, One more question. As the above problem has been solved by you, I want to now if you can help me to highlight the row with the system time. As whenever the excel file opens it will color/highlight the row as per the system time. i.e.- if the system time is 06:40:25 then it...

Hi Narayank991, THAT'S RIGHT! THANK YOU VERY MUCH. WITH RESPECT PUCHA

Hi Narayank991, Thank for so far. Let me tell you what I want to do. I want to divide the duration of sunrise to sunset & from sunset to next day sunrise into five equal parts i,e, total 10 parts. Today's sunrise & sunset are: sunrise time - 06:21:35 sunset time - 17:09:08 sunset time -...

Hi Narayank991, No sir, Only the first one is correct. But the second, third, fourth & fifth are not the same as below. you gave in your xls as given below: 12- 00:12:37 30- 00:05:03 36- 00:04:12 48- 00:03:09 18- 00:08:25 But it will be as below: 12- 00:12:37 30-...

Hi Narayank991, Thankyou, I manage to convert xlsx to xls. Thankyou for the xlsx file. Now would you please help me calculate the second part. Thanks pucha