Search results

Is it possible to Calculate Moon Phases in Excel dynamically every Month

Is it possible to calculated the moon phases in excel dynamically every month.

I am trying to find the event occurred as per given range of time. Suppose the time range is 09:14:28 to 09:53:22 want to find the event from the tables and also the time passed in the certain event (minutes and seconds) I have uploaded the excel file. Pl have time to look. Thankyou Pucha

Highlighting cells in a column from the differences of other cells. Sir i am not able to highlight few cells in column from a difference of other cells. I have uploaded a file for your understanding. Kindly check the file.

POSITION OF CELL VALUE IN A RANGE. I WANT TO KNOW WHETHER THE OPEN PRICE IS IN "OVERSOLD ZONE" OR IN "OVER BOUGHT ZONE". THANKS PUCHA

Hello Sir, Is there any password coding method where an excel file opening in one computer will not open in another unless otherwise a password matching is done. Actually I had given an excel file to a friend's computer but I don't want that he should open that file in some another computer...

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...

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) ...

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 everybody, Friends I would like to know how the time division formula used to divide time in excel. Like the time from 6.00 am to 6.00 pm diving it into 5 equal time period. Example 06:24:02 hrs to 19:01:21 hrs is equal to 02:31:28 hrs each if divided by 5times. This is one part...

Hi everybody, I want to copy data(values only) from the cells which are updating regularly from a source into another workbook. These are stock values. I already got help on this issue before on this forum "http://chandoo.org/forums/topic/auto-refresh-stock-value-copied-to-next-row" But...

Hi, I want to match the current time now() function in a cell with the range of time in Column A and highlighting by conditional formatting. 05:30 AM 05:31 AM 05:32 AM 05:33 AM 05:34 AM 05:35 AM 05:36 AM 05:37 AM 05:38 AM 05:39 AM 05:40 AM 05:41 AM 05:42 AM -------- --------...

Hi I am importing the data (Stock) in this manner, (A1 to A4) & (B1 to B4). I am using Excel 2003. I am using auto refresh for one minute. A1 | Feb 24, 10:35 A2 | 28889.00 243.00 (0.85%) A3 | Volume A4 | 40181 B1 | Low B2 | High B3 | 28723 B4 | 28944 Firstly, I would like these...

I have the stock value which gets auto refresh every minute. I want to copy the stock value changed every minute to next row automatically, i.e. every time stock value changes it will go to next row along with the time in another cell, so that I can make a chart out of it. Is there any formula...