1. E

    How to check this database for duplicates?

    Hi all. I prepared a small example database but it seems that I'm not allowed to post an attachment so I'll try and explain my dilemma by using one of the above tables. <tbody> A B C D E F G etc etc etc etc 39 6 23 34 2 7 26 8 3 35 18 22 7 23 2 39 6...
  2. A

    Show results based on 3 Data Validation list

    Hi community, I have big table of monthly spending, i wanna know how can i show results based on Data Validation list choice, 1-List shows Models ( E:E ) 2-List shows Department ( B:B ) 3-List shows Month I need formula to return matching all 3 list, can anybody help me please?
  3. S

    IF or Product

    Dear kind friends of mrexcel I have another problem that is keeping me stuck and I show you. In an a cell the results is the product: =PRODUCT(Q109,J$3) In the same cellar I want also the condition =IF(U109>0, 0, IF(V109>0.5,0, IF(W109>0,0))) So, I want to combinate this two different...
  4. W

    Need Help with Array Formula to return multiple results for specified criteria

    Hello Excel Users! I need some assistance on an array formula for a summary table that will show multiple results for a set of criteria: Selected Employee Selected Year Only Leave Types: Call Off, In Late, Leave Early The first formula I tried with the leave type conditions but it said I was...
  5. L

    count if doubling results

    Hi, It may be the time of night, but i can't for the life of me figure out how to stop my formula from doubling some results. The formula i am using is =COUNTIF(W251:W273,"*O*")+COUNTIF(W251:W273,"*+*") The formula is to count how many overtime shifts are being worked that day. The cell will...
  6. S

    Search sheet and pull results into a list box based on criteria

    I have a sheet with headers SKU, Name and Stock. I would like to create an userform with 3 textboxes and 3 search buttons below the textboxes to perform a search whatever i enter into each box and place the found results into a listbox for easy viewing. I can write a macro to do a search on...
  7. S

    Countif vba???

    I am trying to find a away to count how may times an employee number shows in Column F and results in Column U. I just can't get it to work with a formula let alone a VBA! I need the information to use in a formula to pro rate costs. I need the information to look like this: EE #...
  8. Beatrice

    Auto Run "Import Database" upon open file

    I need some help here as still learning Excel Macros I have few sets of code within an excel file. 1) clear "results" data if "input" criteria has any change 2) Export "results" as a separated file in values only - button 3) Import "Database"- button So far, I tested them separately, all are...
  9. K

    Search in a Cell and Return Associate Value

    Hello, I have two tabs. [TAB1] is where I want to place my results. I want the results starting in columns C and moving right, as many columns as need be. I am hoping I can limit the columns the results section will be by only returning unique results (i.e. if there are three reference IDs...
  10. R

    Excel - GETPIVOTDATA - need formula to get each pivot entry's value from PT

    So I am trying to extract all of the totals for each element of a pivot table. I don't normally use PTs and this one is not mine. I need to compare each total to my data to see if I agree with the results of the PT. this is the formula that I have: =L5-GETPIVOTDATA("[Measures].[Sum of...
  11. K

    index match ?

    i have several sheets. One is called Dropdown.Template in cell I4 i have a dropdown list with 5 entries one in is "ITEM" in cell h4 is the count of that Item (107) in a table (not an excel table: I just call it that) on sheet called Lists in range F13:F362. In cell I7 on...
  12. J

    IF with more conditions

    So this is the issue: If Name (column A), Surname (column B) and Mark (column C) match with list of Name (Column E); Surname (Column F) and Place (Column G), then answer is YES, otherwise NO. I tried with =IF(COUNTIFS($E$2:$E$5;A2;$F$2:$F$5;B2;$G$2:$G$4;C2);"YES";"NO"), but didnt get correct...
  13. E

    VBV: How do I enter percentage formatting (e.g. 0.000%) as a string without Excel converting?

    We have a macro that reviews all the formatting of one spreadsheet against another spreadsheet. My problem: If spreadsheet "A" has a percentage formatting of 0.00% and spreadsheet "B" has a percentage formatting of 0.000%, when entering the results in a separate "Results" spreadsheet, Excel...
  14. J

    Need proper formula for max

    Dear All Hi, <tbody> #FFFF00[/URL] , align: center"]Location #FFFF00[/URL] , align: center"]KM #FFFF00[/URL] , align: center"]Needed Output #FFFFFF[/URL] , align: center"]CHIKHALI #FFFFFF[/URL] , align: center"]70 #FFFFFF[/URL] , align: center"]70 #FFFFFF[/URL] , align...
  15. D

    Displaying a List without blank rows

    I have a sheet that has two columns - one with a name and the other a date. I use another sheet to show all results for a certain date. For example, sheet one shows: David 10/1/19 Adam 9/30/19 Mary 8/1/19 Jill 8/15/19 Mark 10/1/19 Sheet two then has a user defined date input. Say, for...
  16. T

    Wildcard for MSQuery not Working

    I want to us * in a drop down list to return all results of a query. This is not working for some reason. The data has "y", "n", and i want to use * to pull all results when I change the drop down selection. Any ideas why? Thanks, Trent
  17. baitmaster

    SQL calculating two different things from same data

    Hi, I'm trying to use SQL within VBA to calculate several related things at once, but I'm doing something wrong I have 4 columns I'm interested in: ID, Description, Value and Date (see code for exact labels). I want to return a dataset that contains - unique ID - unique Description - sum of all...
  18. cyrilbrd

    Average header if range fits condition

    <tbody> 1 2 3 4 5 6 7 8 x x x x x x x x </tbody> Given the above, the results should be 4.625
  19. S

    Cell contain multiple text

    Hi I need assistance to build a formula for the below scenario, BB,DN = HB BB,DN,LN = FB If cell A1 contains " BB,DN " I want the result to go B1 as " HB" and if cell A1 contains " BB,DN,LN" results to be in B1 as "FB" <tbody> <tbody> BB,DN,LN, FB BB,DN HB </tbody>...
  20. willow1985

    Countif for entire current month and previous month

    I am looking for a formula that counts all the dates in a list of the current month and of the previous month. I have this formula but I am getting no results when I should be receiving: 210 results =COUNTIF(G2:G1000000,MONTH(TODAY())) Any help would be appreciated Thank you Carla

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