circula reference warning office 2007 xp pro excel News and Other Resources

Q&A

I use MS Excel 2010. I have a list that conains email and non-email address

January 18, 2013 1:28pm PST

I use MS Excel 2010. I have a list that conains email and non-email address I used the FIND and MID commands,using the "@" as the midstring but could only sort the fields to the right, truncating...

4 Started by edwardfowler | Latest comment by johbelnel@...

Q&A

Summarize data in excel 07

January 15, 2013 7:14am PST

Summarize data in excel 07 How to summarize data by year or month from below table: Date Sales US$ Customer name 01.01.2011 100 MAC 01.02.2011 200...

4 Started by loveatallca | Latest comment by wizard57m-cnet

Q&A

Need Help with Excel Nested IF/AND Statements

December 14, 2012 7:36am PST

Need Help with Excel Nested IF/AND Statements I am using Excel for Trainng Registers, but having problems getting the right formula in excel. I have 2 drop downs, 1 for Training Type and 1 for...

1 Latest comment by Jmcle008

Q&A

How to sum up data with dynamic selection using formula in Excel?

October 15, 2012 1:28am PDT

How to sum up data with dynamic selection using formula in Excel? Hello all, How to sum up the data with dynamic selection using formula in Excel? For example: In row 1, I wanted sum up...

1 Latest comment by Stephen Lam

Q&A

Excel find and replace formula

October 7, 2012 8:35am PDT

Excel find and replace formula Hi everybody. I am forex and options trader. Options contracts look like this: 'GOOG 121005C770" or "GOOG 121005P770". I need to have a formula that can lookup the...

3 Latest comment by eilli

Q&A

How do I correct Excel & Word crashes?

October 3, 2012 7:33am PDT

How do I correct Excel & Word crashes? When I try to save a Word or Excel (Office 2007) file the programs stop responding and shut down. This problem started yesterday before I installed Evernote....

4 Started by johnsonhw@... | Latest comment by jk20092010

Q&A

Excel Nested IF

September 26, 2012 9:52am PDT

Excel Nested IF Please tell me why this IF statement won't work completely? =IF(B2=5,"Exceeds Expectations",IF(3,"Meets Expectations",IF(1,"Needs Improvement",IF(" "," ")))).The first two...

2 Started by mslwill | Latest comment by cleaverx@...

Q&A

Plot only non-zero value in Excel Bar graph

September 25, 2012 11:06am PDT

Plot only non-zero value in Excel Bar graph I want the bar graph to show only those bars that have non-zero value . How it could be possible ? see link www DOT excelforum DOT...

2 Started by noman999 | Latest comment by robo_dev

Q&A

Can I insert multiple columns in between multiple columns in Excel?

September 24, 2012 4:17pm PDT

Can I insert multiple columns in between multiple columns in Excel? I have 75 columns but I want to insert two additional columns between each one. Can I do that with one or two commands?

1 Latest comment by carola@...

Q&A

Help with Excel nested function

September 23, 2012 8:34pm PDT

Help with Excel nested function Hi everyone, I am new to nested functions and am trying to use the following: =IF(NOT(OR(F3:H3)),"Do not...

3 Started by liz749 | Latest comment by cleaverx@...

Q&A

formula in excel that can find the last occurrence of each item in a list

September 20, 2012 9:54pm PDT

formula in excel that can find the last occurrence of each item in a list I need a formula that can find the last occurrence of each item in a list. Scenario: Column A(Products) Column B(Date of...

4 Latest comment by Ding_gi

Q&A

need help using excel

September 15, 2012 9:36pm PDT

need help using excel Hello :) Iam new to excel and need to know if it is possible to even do this.my manager does a basic schedule which is fine but the issues is that daily the employees are...

2 Started by MOOKIESMAMA | Latest comment by PurpleSkys

Q&A

Excel: Dropdown list depending on colors

September 13, 2012 12:38am PDT

Excel: Dropdown list depending on colors Hi, I have 2 column say City(Column) & Area(Column B) within City. I need to create a dropdown list for column B depending on the Background Color Present...

2 Started by sagar.morakhia | Latest comment by richardhx

Q&A

MS Excel 2007 Lookup in Another Workbook

August 29, 2012 7:33am PDT

MS Excel 2007 Lookup in Another Workbook Hello everyone. I have a complicated lookup that I need to do from 2 seperate workbooks. I will try to keep it simple. I am needing to place a value into...

2 Started by s2h21 | Latest comment by Darryl~

Q&A

Excel sheet screwing up royal.

August 25, 2012 6:26am PDT

Excel sheet screwing up royal. I have a client that has an excel sheet that they have been using forever. Seems like every month one of the workbooks gets very hard to manipulate. Going from cell...

1 Latest comment by SerrJ215@...

Q&A

Problem pasting Word text into Excel

August 24, 2012 9:00am PDT

Problem pasting Word text into Excel When I copy table text in Word and try to paste it into a specific cell in Excel, it spans multiple cells vertically down from the chosen Excel cell. I have...

2 Started by donpho | Latest comment by PurpleSkys

Q&A

how to prepare an excel considering in and out time?

August 16, 2012 12:06am PDT

how to prepare an excel considering in and out time? how can i calculate the working hours on daily and weekly basis considering in and out times? thus all the time should be in hr:m:s.

1 Latest comment by 17/04/1978

Q&A

How to separate out dates in excel?

July 24, 2012 9:02am PDT

How to separate out dates in excel? I have dates from 2008 - 2015 in one column and want to group them in date order, how do I write the formula? Sort or filter Hi, If you just want them listed...

3 Latest comment by grandmistress

Q&A

vlookup returns a zero need blanks

July 21, 2012 1:02pm PDT

vlookup returns a zero need blanks Excels vlookup finds the lookup value but returns a zero if blank need it to return a blank instead. Maybe there is a number formatting that suppresses 0? You...

3 Started by glendalelest@... | Latest comment by rodney.mcmullan@...

Q&A

Transposing an Array of data into a single column in Excel

July 11, 2012 4:12am PDT

Transposing an Array of data into a single column in Excel I have a bunch of data which is spread into an Excel sheet spanning 24 columns and abut 1000 rows. For each of the 1000 rows I need all...

2 Started by Shriks | Latest comment by jladen@...