results

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

<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

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

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