Functions
in [Excel]
|
Excel Doc Hello, I have a work phone list that I created in excel and have posted on our share drive. What I would like to do is let everyone in the department have access to edit the document while on the share drive but only their information, no one elses, but yet can view everyone elses info. Can you help? Thanks.... 17 May 2010 15:48
Calculate the total overlapping time of multiple tasks, excluding non-working times I am developing a tracking calculator for an overall process. Within the overall process, there are 3 steps which are completed. These steps can be completed independently from one another, but can also (sometimes) overlap. I am trying to determine the total time for the overall process (from beginning to end), wit... 19 May 2010 13:48
how do I attach a jpeg to a cell I am trying to have a button or link in a cell that when clicked will open up a jpeg that is also attached to (part of) the excel file. ... 18 May 2010 18:09
Auto updating muiltiple spreadsheets in Excel 2007 I have 50 spreadsheets which calculate aging on past due invoices. I use the =now and =today functions to determine which accounts are past due. I created a master sheet which pulls this information and displays it at a glance. The problem is: the dates don't update on the 50 seperate sheets unless the she... 17 May 2010 18:01
count number of columns based on values across a row i need to calcuate the number of columns that have a value greater than zero within a particular row. ... 17 May 2010 14:40
Need help with if function Sorry if this is a double post. I don't see my first one. Need help with the if function. If cell K84 says Peds, I need N84 to say Peds. If cell K84 says Psy, I need N84 to say Psy. If K84 has any other description, I need N84 to say Other. How do I write this? Thanks for your help. -- Donna ... 17 May 2010 15:48
How do I calculate the 3 sigma of a number? The number I'm working with is 1.67E6, and I need the 1st and 3rd sigma points. ... 17 May 2010 16:55
Need help with if function Hello all. Need help with the if function. If cell K84 says Peds, I need N84 to say Peds. If cell K84 says Psy, I need N84 to say Psy. If K84 has any other description, I need N84 to say Other. How do I write this? Thanks for your help. Donna ... 17 May 2010 13:33
Convert a text in a date format Hi I have imported a file where there is a field that is suposed to contain a date. It was transformed in text, like 22FEB2010. I need to treat this field as date. How can i transform it in a date format? Tks ... 18 May 2010 14:48
Looping Format Hi everyone, I need some help a looping format, here is the problem: I have data in col A B C , and i need each time both A1 B1 C1 is equal to zero the text color is white, and so on until A100 B100 C100; i have thinking in someting but is not working... Can you help me.... Thanks _________________... 17 May 2010 13:33 |