- Subscribe to this page:
- RSS
- Email Alert
excel
(1816 results)-
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...
-
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...
-
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 JSerrago@...
-
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@...
