eric w

  1. T

    Copy Data from a Cell to another based 2 conditions

    Hello! I can't seem to figure out how to accomplish the below 2 functions, is it even possible: 1.) If there is an "X" in D and a value in O, then copy value from O to R 2.) If there is a Value in R then auto-populate a "X" in AC; AC currently has a formula of which populates AD and I still...
  2. A

    Urgent method required to achieve the desired goal in pivot table using following data

    Below is my data which I am able to achieve using this formula...
  3. A

    Formula required to completed the below condition

    Hello Everyone, I have a query below with these condition, requesting to please help me solve this. QA Tag Mod Tag Difference 0c103e02,9961fd48,a4b63c62,a7eb2d76,d044fd17,ea1bea7e 725f5ee4,a7eb2d76 0c103e02 0c103e02,9961fd48,a4b63c62,a7eb2d76,cafa8afb,d044fd17,ea1bea7e...
  4. BonScie

    Generate a set of random numbers with the specific AVERAGE

    Hi there, upon searching around the net I came across with Mr.Eric W.'s reply with one of the post here regarding generating random numbers with target overall total. Link: generating a set of random numbers to total a set value I have pretty much same problem but the target is AVERAGE of the...
  5. S

    "How can I change the ranges on these functions?"

    Dear experts, I need your help to modify the ranges like winter from Oct-March to Oct-Feb and 3months from April-June to 4months March-June, remaining (July-Sep) will be same. So kindly help me in this regard, your kind assistance will be highly appreciated.

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