shot

  1. S

    Subtracting a column in pivot able

    I have a pivot table & I'm trying to get a difference from two columns within the pivot table. This is a screen shot of pivot table. [Imgur](https://i.imgur.com/iUyA5F2.png) This is a screen shot of the fields selected. [Imgur](https://i.imgur.com/wjl25eZ.png) I've tried adding a...
  2. K

    Finding a certain value from a list of matching values

    So what i am doing is scanning barcodes, the only problem i have is that the barcodes on products are all the same. I have several distributors that supply the same products but at mostly different prices. I would like to be able to tell excell to find that product ( which i have already done...
  3. K

    Finding a certain value from a list of matching values

    So what i am doing is scanning barcodes, the only problem i have is that the barcodes on products are all the same. I have several distributors that supply the same products but at mostly different prices. I would like to be able to tell excell to find that product ( which i have already done...
  4. D

    IF formula help

    Hey Guys - i need to get the specific cell value if the answer is "NO" can you help ? pls see the snap shot i have attached and as per that. B3 should have C3 value instead of "NO" https://ibb.co/eHHO79
  5. A

    VBA Coding Query/ideas

    Hi all, I am writing some code to fix up some survey information. The type of data I receive has a x, y and z co-ordinates for the same points, lets say a shot at the ground line, a shot at the top of a structure and shots part way up the structure. The software that will be importing this...
  6. J

    -2147024809 (80070057) run time error - How to fix?

    Dear, I see a run time error pop-up when I open my excel file. I don't know how to attach the screen shot to this thread... -2147024809 (80070057) run time error Can anybody help me to understand this and let me know how to fix it?
  7. T

    Screenshot IE with visible = false

    Hi all, Is it possible to open Internet explorer via VBA, navigate to Google, take a screen shot of the Google home page and save that screen shot in a specified location (all through VBA)? This should all happen in the background, i.e. Internet Explorer shouldn't be visible to the user. Thanks!
  8. BussellT

    1st, 2nd, 3rd placing with variables

    I need to place players 1st, 2nd, 3rd, etc. on a score sheet. 1 win = 2 points, Loss = 0 To break ties (Which are many) there is a shot differential (Shots For - Shots Against). There are 3 games w/ a total of 6 game points possible. The RANK does not work, because any team w/ 6 game points is...
  9. J

    Attachments

    Hello I was hoping to put a screen shot of my Excel worksheet and have looked at the options under the Forum guidelines but I can't seem to get any to work with Excel 2016. Does anyone know if they all should work with this version? Thanks

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