iam

  1. B

    Formula Error

    Its a huge formula iam trying to take cells in specific sheet to maser sheet. can anyone please fix the formula by using specific sheet and range,there are 4 more sheets,i need to consider different ranges in different sheets. thats y iam trying to use this formula. MyFormulas =...
  2. M

    VBA clean data

    Hi there everyone! i have to edit the following table. It looks like this(see following first pic): There are different sorts of labels in this table. I order to get best results i need to align under each other. Like in my next picture: After each Sort there should be a blank page/label...
  3. A

    How to coad iferror along with vlookup function in VBA

    Hi I am able to coad vlookup in VBA, however iam not able to multi function (iferror+vlookup) in VBA Coad.
  4. M

    Sumproduct Query with "{ }"

    Why iam getting #N/A error in my formula IF I put more than 2 criteria in "{}"? SUMPRODUCT((WageReporter_CC=A5)*(WageReporter_EmpType={"A","C"})*(WageReporter_ManpowerCateg={"A1","A2","C1"})*(WageReporter_Code={1007,1006})*(WageReporter_Amount)
  5. B

    i am not getting output with this code

    Sub usingthecolumns_androwsproperty_to_spcify_a_range() Range("A1:B9, C10:D19").Rows.Count End Sub iam not getting count with this code OUTPUT SHOULD COME IN F3
  6. B

    this code not working

    iam in learning stage can anyone help me out y this code not working Sub notworking() ThisWorkbook.Worksheets(1).Range("A1:B10").cells (9) End Sub

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