Find an Online Tutor Now

166 Answered Questions for the topic Excel


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


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


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


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


Divide entire column in excel (accounting) in 2 separate column (symbol + value)?

how to divide excel field with format accounting omitted, for example: $ 220 € 140 $ 220 € 140 $ 220 € 140 $ 220 € 140 etc...etc... So, from one field-column A, to get 2 column A (for accounting... more


Excel as a data source in SSRS Query a Specific Column of a Sheet?

I want to query the data from an excel file utilizing ODBC System DSN for Excel 12.0. What will be the right syntax to query specific columns from a worksheet and not the whole worksheet like... more


ssrs exporting to excel as csv?

I am calling SSRS reports from an in house piece of software. All the reports made before me render as xlsx or xls and mine continuously are rendering as csv files which is messing up my... more


Save Excel File with a Timestamp when Exporting a Report in SSRS 2016?

I've been fiddling around with SSRS 2016 and tried, without any success, to add a timestamp to the saved excel file when exporting a report. Is there a way, preferably one that isn't much of a... more


VBA number formatting?

I am writing a macro package to format numbers in accounting format so that I don't have to click "alt - h - fm" every time I want to make a number accounting format (which my job requires). I have... more


SSRS: creating a report optimized for exporting to Excel?

I have a client that needs a particular report that he can export to excel. I haven’t started to build the report, but I’m thinking the best way to do this is to keep the report as simple as... more


Need help regarding Excel formula

If multiple values are given in Excel sheets, then how to calculate the any percentage on fixed value for example we have 18000 thousand rupees but we need to Calculate any percentage on only 15000... more


Excel - Formula is guessing wrong in Fill Down command?

I know this should be simple but I can't work it out. I have a column that is calculated with the sum of the 3 columns to the left of it. E.g. SUM(C1-C3). When I fill that down, each cell... more


What does set print area mean in Excel?


Why do we use a dollar sign in Excel?


What is the formula in Excel for a zigzag indicator?


How do you rank a tie in Excel?

1 3 4 5 6 7

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.