How to split cell based on capitalised suburb name3998 (11/16/2009 6:09:01 AM) UtfHi
I have data such as the following in a single cell per line
Level 8, 160 Marsden St, PARRAMATTA
15 Carter Street, HOMEBUSH BAY
223 - 239 Liverpool Road, ASHFIELD
I want to put the Suburb name int...
Not able to see all data but can see on another computer0808 (11/16/2009 5:06:01 AM) UtfHi,
I am using SAP application and if i retrive the excel file from SAP i can
see only 48 lines where as i should see 110 lines but if i opened that same
excel file in another computer then i can see all...
Increase cell value by 1 month13285 (11/16/2009 3:48:01 AM) UtfWhat formula do I use to increase cells by 1 month?
i.e. If I have December 2009 in A1, how do I get Jan 2010, Feb 2010, etc. in
A2, A3, etc.?
PowerPivot Beta0710 (11/16/2009 4:31:02 AM) UtfIf you have not seen PowerPivot you might want to check it out. It's the
collaboration between the Excel and SQL teams in Office 2010. If you use
Pivots today, you will love what PowerPivot can do for you....
Why is this formula returning "#Name?"?0742 (11/16/2009 1:11:31 AM) RPSHi,
I'm using the attached formula across 30+ rows on a number of
worksheets in a number of workbooks. On every worksheet the formula
returns #Name? in Row 17, but returns the correct value everywhere
Down Arrow problems2811 (11/15/2009 12:04:01 AM) UtfI am using Excel 2007 and whenever I press my down arrow on the keyboard it
moves down one cell and over one cell to the right. I am trying to figure out
what setting has made it this way.
Does anyone k...
Excel Help Please quick question7656 (11/15/2009 2:13:01 PM) Utfi want to have a cell automatically fill its self in when another cell says a
eg - if i type "blue" into D5 i want D6 to automatically change to "yes"
Is this possible
min,average>0 if 52 cells read zero2785 (11/15/2009 5:43:02 PM) UtfI have 52 cells w265 that all read zero until data is entered this means one
cell in each worksheet example Week 1 w265, week 2 w265, week 3 w265 to week
52 w265. on a seperate work sheet im trying to cacul...
Combining 2 Tables Dynamically into third new Table11013 (11/15/2009 6:32:03 AM) UtfBelow is data from two tables. How to I combine them dynamically, while at
the same time selecting records that belong to customer CARL? I am familiar
with VLOOKUP, etc, I just don't know how to combine t...
Excel's localization of scientific notation1953 (11/15/2009 4:56:04 PM) GregDoes Excel use "E+" and "E-" for scientific notation for all locales?
Or are there some locales for which it uses different characters?
putting a column of names into alphabetical order13417 (11/15/2009 10:06:01 AM) UtfI have collected data with names against dates and treatments and wish to
rearrange the spreadshett into alphabetical order by name.
Some names have spaces in the name column as there may be multiple entri...
Vlookup only the last 6 characters23949 (11/14/2009 8:49:02 PM) UtfI have a spreadsheet starting in cell A4. I want to lookup only the last 6
digits in column A and then lookup the value in column J and return the
appropriate value from column K.
The values in column A ...
VLOOKUP Question 11-14-0931105 (11/14/2009 10:01:01 PM) UtfI feel stupid but I cant figure out what is wrong with my forumla. It will
only return #N/A.
Here is the formula:
Where "List" is another tab on the same work...