Functions

Index on pivot report filter
How do I alphabetically sort ? ... 22 Feb 2010 07:26

i am using office 2007 how can i put in exel the numbers in arabic
i am using office 2007 how can i put in exel the numbers in arabic Mohamed Attia wrote: Arabic Numbers 09-Feb-09 Dear All, I need your support to tell me how can I change the numbers in excel 2007 from English writing to Arabic numbers, it very important for me and I cant work because if this issue I t... 22 Feb 2010 07:26

Check Dynamic Named Range
Is there an easy way to check the actual range being defined by a dynamic named range? ... 22 Feb 2010 10:45

Reverse word
Hi, How can I reverse, with Excel, the letters in a certain cell? For example; I want Excel to rewrite the word "black" as "kcalb" in cell A1?. Using Excel 2003. Thanks, Amnon ... 23 Feb 2010 19:24

How do I format cells in Excel to make 175/5 read 175?
I want to copy a list of numbers from a web site into a spreadsheet. The numbers all have a / in them, and this copies to the spreadsheet. Example 195/5. I would like to be able to format the cells so that the numbers will read 195 (losing the / and any digits after it. Using another column with a formula t... 21 Feb 2010 22:44

Sum with multiple conditions
I have a source data sheet which has the following Column E is the division Column F represents the day of the month (ex: 1 thru 31) Column G represents the month (ex 1 thru 12) Column H represents the year (ex 2009 2010) Column I represent s the sales revenue Column N represents whether the sale went through (... 22 Feb 2010 18:43

Desire Weekday returned in every 5th Cell
I have a worksheet with Monday, March 15, 2010 in Cell A2. I'd like to have a formula that will put Tuesday, March 16, 2010 in the fifth cell after that (in this case Cell A7) and so on......I do not want Saturdays/Sundays to show up. Any idea if this can be done and if so, with what formula? ... 21 Feb 2010 13:47

help with formula =valuesA1
I have a cell with a very long formula in it. I am looking for a formula that will copy the values to another cell. Something like =valuesA1 Anyone know how to accomplish that? ... 21 Feb 2010 09:17

Sum in another cell with reference to another
I need to add cells which only have reference to another eg: PNS Kilbirnie 2.0 NW Newtown 1.0 NW Island Bay 1.5 NW Metro 1.0 PNS Kilbirnie 1.0 eg: Need to add only the "PNS Kilbirnie" totals but these are also in other columns similar to above. At the moment these two columns are A & B, then I need to ... 21 Feb 2010 03:51

Conditional Accounts receivable Aging Analysis
Hi I need a formula for conditional accounts receivable aging analysis. Funds are provided to project managers in the field for operational expenses. Each Project Manager has an established Imprest Amount. When cash is advanced, an advance number is assigned and any settlements received are applied against ... 21 Feb 2010 02:46