168 Answered Questions for the topic Excel


How Do I Create a Vlookup?

Excel: I need to take given data and sort between f, d, or Both. Then I need to separate the data once determined by f or d pounds

So, imagine there is an excel sheet with a column full of f or d values, another with random minute values, and 5 different zone columns with a number in only one of these per row(These 5 columns... more


How do I link my excel spread sheet contents over to a word document

I need help with trying to link my excel spreadsheet contents over to a word document (such that, when I do the data entry into excel, it also updates the word document) I have taken a basic course... more


if function in excel

I have scores from ranging from 1 to 14 that I would like to prorate down to a number out of 5. Is there a way to do this with an IF function?
Excel Maths


help with working out sell price after taking into account all variables

need a formular creating which will calculate the sell price after taking into account the following variables. We wont know the sale price, so the caluclation needs to automatically calculate this... more


Building a dynamic table in excel based on dropdown lists options

I need to create a fitness training program that contains 4 dropdown lists (Program 1-3, Phase 1-3, Week 1-4, Day 1-5) and that each possible combination of these variables will retrieve a... more


How can I learn Microsoft Excel?



Automating and adding flexibility to Excel GoalSeek and Solver?

Suppose you want to compare several "What-If" scenarios with complex dependencies between the variables. You plan to use GoalSeek or Solver to find the input value that makes two outcome values the... more


help with excel

I can’t figure out how to make this happen. i have a user form created in excel. i have radio buttons, drop down lists and a text box on the userform. for example: if in the drop down list I choose... more


Can you help me with flash fill?

Help with analyzing Rank Data with Weighted Responses

I'm working in Excel on data related to hotels. Responses need to be weighted based the percent of total rooms in the sample. (E.g. Hotel A has 12 rooms, sample is 100 rooms spread over x hotels.... more


Deleting Two Columns Simultaneously?

The following code deletes Column J only: If Application.WorksheetFunction.Sum(Range("J:J").SpecialCells(xlCellTypeVisible)) _ =... more


Number field turned out as text in Excel, SSRS?

My SSRS reports one of the field is using this expression, where the field is a number field. I want to see blank field is the value is `0`. =IIf(Fields!PERIOD02_VALUE.Value <>... more

Find Excel three-columns match in two different sheets?

I've three sheets from differents periods of several companies It happens that not same accounts were used on all periods. I need to compare two or three companies from two different periods. I've... more

SSRS Issue with values that are text and number exporting into excel?

I am having an issue where I have similar hyphenated values 1304-4(text) and 1306 (number) The main issue I am trying to overcome, is when I export my SSRS report (.rdl) to excel, I get an error in... more

Column widths changing when exporting from SSRS to Excel?

I have a simple SSRS report which contains a single table with a header row, footer row and any number of detail rows. The width of the report and table is 7 inches and the report has .5 inch... more

SSRS and maps of route from data?

I have data that has the longitude and latitude values for a point of origin, stops and the return point of origin. I'd like to be able to create a matrix that uses this information from an Excel... more

SSRS Large Report -- Error When Exporting to Excel?

We are having an issue when exporting a large SSRS report to Excel. We receive the following error when it is run over a three-year date range. If the report is run for each of the years... more

How to Lock cells in SSRS while exporting to Excel?

I have a report in SSRS 2008. I need to export it to excel and lock some columns and rows. For example I have 10 columns and 500 rows in excel. 1- I want first two column can't be edited. Other... more


Create an excel spreadsheet that gets quotes for each quantity and each markup on cost at each quantity.

Campus Manager needs a quote for a product. Here are our inputs: Shirt Cost: $12 per shirt Print Cost: $14 per shirt Set Up Cost For Order: $20 flat cost Shipping Cost: $1 per shirt Sales Manager... more

tsql to export and attach SSRS report to email?

I don't think there's an easy way to do this, but here goes. We have an `SSRS` report that can be invoked with `http://MyServer/ReportServer/Pages/ReportViewer.aspx?%2fSales%2fSalesReport` We... more

Excel formula that multiplies the value of a cell times 2 only if it is under $.99?

Hello and thank you for your help! I am writing a formula to help me calculate coupon deals for my shopping trip. My store doubles coupons $.99 or under, so I need a formula that does the... more


Excel VBA Code to pull SSRS data as a dataset?

I can’t seem to find a solution for my problem no matter how much I Google. (Please excuse my verbosity in the following explanation) My process is that I have to go to the SSRS web page, run my... more

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.


Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.