analysts

  1. W

    VLOOKUP(Index/Match) data from another sheet, using 2 separate dropdowns

    I've looked at several index/match and index/indirect formulas here but I cannot wrap my head around this. I have all data on 1 sheet, but need to show the results from the formula on another sheet. Here is what I am working with: Sheet Analysts has all the data I need. Column A is AGENT ID...
  2. D

    optimizing weight of historic forecasts to apply to future forecast

    First of all, I'm an Excel novice and much of the information on here is over my head. With that being said, I'm not expecting to be spoon-fed the solution but would love someone to at least point me in the direction of additional research I need to pursue. I'm looking for a solution to a...
  3. S

    Adjust CSV Output to Remove Xtra Commas

    Need help modifying the below code to meet my requirement. Any help would be greatly appreciated. I have 100's of files to convert. Option Explicit Sub CreateCIF() Dim ws As Worksheet Dim rng As Range Dim strFileName As String Dim FF As Long Dim NoVals As Long Dim arrVals Set ws =...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top