tricks

  1. S

    Date Slider, Advanced Requirement, Question & Advice

    Hi, I have a bookmark that pops out for filtering a report. I already had a filter in there for a Relative Date field for Next 2 days, the reason being, this field filters the report for the current day at all times as our client works around the clock. There is a now a requirement by the...
  2. D

    Copy pasting cells from one worksheet to another in Excel

    Hello everybody, I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2). Currently, I have just set the fields in my "Order form" sheet = the...
  3. B

    1 hour video on Excel tips & tricks

    https://www.youtube.com/watch?v=u3HKXOKzYzA
  4. B

    Match Formula to populate unique values in Range

    Can someone help me on below formula, used to populate unique values from a Range "NAME", present in DEPT "Science" MATCH(0,COUNTIF($B$<wbr>1:B1,NAME)+(DEPT<>"Science"),0) Complete Formula: {=INDEX(NAME,MATCH(0,COUNTIF($B$<wbr>1:B1,NAME)+(DEPT<>"Science"),0))} Note: This formula is used in...
  5. C

    Trick to validate the numbers

    Hi everyone, I'm trying to matched up my funding and payment = 0. I have more than 60K data and I need some tricks to clean up the data faster, please help. In the below table, I have row 1,2,7 sum up to 0, I have row 3 and 6 sump up to 0. etc... Please help <tbody> 1/1 1000 1/1 -500 1/2...
  6. D

    Formula to bring Last Values of the multiple columns

    Hi, I am looking for a suitable trick to get last values of the multiple columns, as shown in the table below. I am using a following formula (which is just half being a trial) which is working fine but it would be too lengthy. Just want to get an appropriate one. Thanks you...
  7. M

    Trick Question

    Dear I need to creat a formula in excel for my daughter for school that will show how many different denominations can be done to get to a fixed value of 300 only using values of 200, 100, 50, 20 & 10. Can any body help Regards Mark
  8. J

    Tips and tricks

    I thought maybe we could start a thread where everybody shares their favorite tips, tricks, and keyboard shortcuts for excel. My favorite is the F2 keyboard shortcut for bringing the cursor into a cell instead of clicking on it. What is yours?

This Week's Hot Topics

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
Top