## solution

Suppose =IFERROR(5000/2,1000)+100 is entered into a cell. What is the resulting output of this formula? By:

Suppose =IFERROR(5000/2,1000)+100 is entered into a cell. What is the resulting output of this formula? By:

I have some product list that are sold every month. I need to find the rate of sale for them now the rate of sale for them now the rate of sale should be sum …

Hi Guys, I would like to keep a value constant for the first cell link in this and then change it to the next 4 automatically from $2 to $3. Then after …

Hi all, I need some help trying to nut out a conditional formating formula. I need to only highlight cells that contain 3 or more blanks in sequence in a row …

I have a file which has the column headers Full Name, Question, Answer. I need the data in such a way so that the column headers are Full Name, Question 1, …

Hello there, I want to lock particular culumn.. i want them to be automatically locked after the value is change… and i tried this code.. Private Sub …

I have a budget spreadsheet to which I have added notes to remind me of details about expenses. I enter the notes using shift F2. I used to be able …

Hi all, I need help with a formula. I am trying to write a formula which looks for whether a name (C1) exists in a list of names (A:A) AND has a …

i have column A1 to A10 and another column B1 to B10 In my Column C1 to C10 the value is from any One of A1-A10 ( that is customer enter) If C1 = …

Hi – thank you for any thoughts on this – grateful for your time. Here’s a formula that calcs a weighted average within a data table. …

I am looking for a formula to go into G2 that finds the combined sum in column D that is adjacent to the product in column C, but for the choice of product to …

I’m creating a spreadsheet to help keep logs of jobs I do daily and weekly. I need a formula to add rows in a column, then subtract a certain amount as …

How do I create a 12-month table with several variables in Excel? Say I start with 5 possible X values and have two growth factors, each with 5 proposed values …

I am trying to make calculation from my dropdown menu. I have following dropdown in sheet 1 in my excel. Category AAA BBB CCC DDD In sheet 2, i have …

How can you delete numerous records on a filter without deleting every record in between. Say we have 40k records and we want to put a filter on that displays …

Hi, I want to create a Userform wherein there are 2 text boxes. The first one adds text to the last row of column A, and the second one adds a hyperlink …

An API returned the following result: { “Global Quote”: { “01. …

ADD SUBJECT(1) FROM RANGE A1-A10 AND ALL THE (1) N THAT ROW WILL ADD FROM C1-C10 A1 C1 1 …

So what I’m doing is hyperlinking my summary page items with each worksheet in the workbook. I’m getting an error in my code on the last line …

I have an excel sheet with 1500 records. I want to insert pagewise subtotals of some columns with numerical data and print. Please help By:

I have a column that has address line data in and I want to see how many unique addresses I have, the issue is the fields have been manually typed in so using …

Dear Excel Geek, I have a program that exports a tab-separated values into the clipboard. When I paste directly into excel (for example at A1), the …

I have two sheets in excel, firstly I am wanting to find out which names are not in sheet 1 but are included in sheet two. Sheet 1 will eventually be …

I have an excel spreadsheet that takes information from a main sheet and uses formulas to break it down into smaller sheets. I also need it to format the …

Three files: One Excel file that I track inventory (MasterInv), and two auto-generated CSV files (CSV1 and CSV2). I set up Task Scheduler to open all three …

what is cells(,5) equal to ? By:

Hello, Please advise on how I can group my dataset. My current dataset: Name T-shirt Size Ali Small Ben Large Thomas Small Cindy Medium Lee …

Hi Guys, I’m working on an Excel VBA form. This form has a button which will attach an object in the excel file. Objective Once the user will …

Hi, Does anyone know what is wrong with this XML: <?xml version=”1.0″ encoding=”utf-8″?> <xs:schema …

I want to look up prices for styles based on which store they are in (field or house). The prices are different for both. For example, I want style 2012 price …

0down votefavorite Hi Im trying to get a code that can take data from multiple cells from sheet1 and place them in the same cell on sheet2 but …

Hello sir i need to know how to show cell name instead of value for example i have sheet which calculate the min value between B1:B10, how to show in another …

How the increase decimal operation is performed in Excel and how they done it? Case 1 : I enter a number in a cell whose number of digit is less …

Let’s say I have two columns in a table, one in which i ender the date, and the other returning the week number using the …

I am wanting to know how to do two things please: 1) I have a worksheet with lots of rows. I want to filter those down so that if Column G says certain words, …

I need to know when various symbols can appear in Excel (Conditional Formatting) Formulas, and when a letter character followed by a number character can …

Hi I’m looking for some code to finish off my userform, the function I require is when a text box is filled with the correct answer (Range (“K8”) it will …