## Excel Related Problems & Solutions

3,306 tags
Refine Tags
Search Tags:

Results 1 - 30 of 3306
[Solved] Auto-insert new row on different worksheet on condition
Summary: Hi, I have a question very similar to another question that was answered in a thread on this site around a year ago. I found that thread very helpful...

[Solved] How to add/remove specific rows based on input options.
Summary: I am really desperately hoping someone can help me with this. Sheet 1 Cell C3: Name Cell D3: User-Input Cell C4: Children Cell D4: Option of either "...

[Solved] Is there a way to simplify this excel formula?
Summary: I'm trying to process a couple of values in Excel, and came up with this formula, which works: =\$A3*B3+\$A4*B4+\$A5*B5+\$A6*B6+\$A7*B7+\$A8*B8+\$A9*B9+\$A10*...

Excel Formula to return cell value with matching text string
Summary: I am working on an excel formula that will return the value of the cell if the text string matches. the problem I am having is the blank cells where ...

[Solved] Formula to check entry for duplicates in same column
Summary: I have this Excel sheet with just one column (A) in which I input just numbers in each row. I would like to create a formula so that each number, befo...

[Solved] Excel formula parse error
Summary: Hello, Can someone please tell me why this is giving me a 'formula parse error'? =IF(ISBLANK(I6),ʺblankʺ,((((I6-I5)*2.3))+(((J6-J5)*0.26)))) Thanks....

[Solved] Check & set the start date after another task end in excel
Summary: I have a schedule control Excel sheet, such as below Item Task Start End "predecessor task" 1 Gather requirement 2016/5/3 ...

[Solved] Mid formula help on excel looking for 2 different symbols
Summary: If In say cell A1 has this text in it J DKNX CVIX K101 - M DKNX CVIC P191 How could I get cell C1 to show only M DKNX CVIC P191 If they are separat...

Alternative suggestions to this select case code?
Summary: Hello all I have a macro that copies all the sheets from two workbooks into a new workbook. That is all good and working. Each sheet contains x-number...

Copying data to another worksheet based on criteria. - VBA
Summary: Maybe I'm just over thinking this, but I couldn't find anything about it anywhere. What I'm trying to do is copy a range of cells from a table on one...

[Solved] Change number in a formula buy referencing a different cell
Summary: Basically I have this formula: =(MIKE!\$B8) and I have a bunch of cells withs Numbers like so: Cell | Cell Number Change C1 | 10 C2 | ...

[Solved] How would I remove text from the begining of data in cell?
Summary: I have a spreadsheet that comes loaded with data but before the company name, there's a line of text that has nothing to do with my purpose and I need...

Macro help to pull company each time it's added to list?
Summary: I hope someone can help with this, it's been about a year since I've worked with Excel and I cannot wrap my head around this! We're trying to track ho...

[Solved] OS for outdated old PCs
Summary: hi friends. ok take this specs - RAM - 32 mb Hard Disk - 16GB rest unknown. its a *very* old PC that i came across, i actually bought it at a very low...

Highlight every second item AFTER copy + paste as values?
Summary: Hello all I have a sheet where I have a lot of items listed in column A. I then have a helper column that changes between FALSE and TRUE if the items ...

[Solved] How can repair corrupt Excel File?
Summary: Greetings, I have a user who was working on an Excel 2007 file from a thumbdrive.. all of a suddem the file will not open and generates the following ...

What formula to use to check current or previous owner?
Summary: Hello all I have some data that looks like the following: A B C D E F G 1 ID Name Date bought Date sold Numerator denominator Owner status 2 111 ...

Can this approach be optimized?
Summary: Hello all Can the following solution be optimized somehow or am I stock with this very slow working array formula? I have a sheet with the following d...

How do you show data from 1 sheet to another based on date?
Summary: I'm building a spreadsheet to compare sports statistics where the match-ups are different every week. I'd like to have a sheet which has each team's ...

SUMIF formula to VBA
Summary: =IF(SUMIFS(FTMRC,FTMRC,VALUE(40),CTN,RPA!E5),40, IF(SUMIFS(FTMRC,FTMRC,VALUE(45),CTN,RPA!E5),45, IF(SUMIFS(FTMRC,FTMRC,VALUE(30),CTN,RPA!E5),30, IF(SU...

[Solved] How to allow data entered only in cells with color
Summary: I am using excel 2013, I have some conditional formatting that changes certain cells red depending on a number entered in a cell. As the user changes ...

[Solved] error is coming while opening xlsx file
Summary: I have an application which exports data into .xlsx format. The excel file of format .xlsx is created through OpenXML. While trying to open it it giv...

[Solved] growth rate formulas, with a twist
Summary: Hi, So here's a tricky one. I tried using CAGR but it doesnt seem to work for me... maybe my logic is wrong. Here is what I want to do: 1 have 37 colu...

[Solved] formula help in excel
Summary: i have 36 columns with an increasing number in each cell left to right... i.e. range is A1 to AJ1 and the numbers start from 7 in A1 and go up to 286 ...

[Solved] how to repair damage excel file
Summary: dear all, I have an Excel file its size about 19 MB and it was work properly, suddenly we can't open this file, and it shows the message "unable to re...

[Solved] Unable to open corrupted MS Excel 2010 file?
Summary: I cannot open corrupt excel file because of virus attack or malware affection, I have corrupted workbook. How to get back corrupted MS Excel file. Any...

[Solved] logical test in IF statement in the form of interval in exce
Summary: I have a table containing student grade averages with the first column containing the names and the second containing the averages, I want to write an...

[Solved] Having trouble creating a If/then,Vlookup statement in Excel
Summary: Is it possible to create an if/then and Vlookup statement in Excel that copies a whole row of information and populates a different workbook once a ke...

[Solved] Lookup a column, if matches, give me the last number...
Summary: Hi there, We are having a problem in our billing where we hire fleet to other departments, and the data entry person is sometimes not matching up the ...

I have lost an excell file 2003 in xp system.
Summary: I have lost an excel file. When I got from my laptop and came back an auto update occurred and I can not find the file now. This just happened in the ...

123456789... ⇓»

Popular Tags