tricks

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...

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...

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

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...

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...

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...

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

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?