stumped

Good morning! Not sure if you smelt the smoke but my brain is fried! Would you mind looking into the below? I'm trying to build a pivot chart that shows capacity vs utilization on each day. Location Max Capacity # Personnel Departure Rental Start Rental Complete Site A 3 2 6 Jan 21 20...

I know this will be obvious, but has stumped me... Trying to adapt the below code to apply for an entire workbook rather than just the active sheet.... Thanks. Sub Clear_ButtonsActiveSheet() Dim I As Long Dim xOLE As Object On Error Resume Next ActiveSheet.Buttons.Delete For...

Hi. This is my first post. Used Excel on and off for a while and manage to get by through googling functions I need but this one has me stumped. I'm collating exam results and trying to create lists of names depending on their scores on another sheet. I've managed this so far...

I'm trying to get a sum by Month (from dates in row 1) and by group (in column A) using sumifs. but am stumped. suggestions? <tbody> A B C D E F 1 WEEKLY 10/05 10/12 10/19 10/26 11/02 2 Group1 91 12 33 64 29 3 Group2 3 6 8 1 0 4 Group3 12 69 3 4 56 5 6 7 MONTHLY...

Hi everyone, I'm stumped. In my excel file, B2 will always have a date. If C2 and D2 may display a date, nothing at all or zeros. I want the correct date to display in E2. B2 always has a date. If C2 has a date that isn't 0, I want to use that one instead of B2. And if D2 has a date that...

I have columns of data. Each column has a title. A, B, C, etc. I want extract the corresponding row item from Column C. I have attached a link to a spreasheet setup to show what I am trying to do. It will clear up my inadequate description. I was going to use HLookup but if I copy it down the...

E4: =IF(F4="Yes","No",IF(OR((ISNUMBER(MATCH(A4,'Remington 700'!$N$7:$N$401,0))),(ISNUMBER(MATCH(A4,'Bighorn TL3'!$N$7:$N$401,0)))),"Yes","No")) F4: =IFNA(IF(OR(IFNA(((VLOOKUP(A4,'Remington 700'!$N$7:$O$400,2,FALSE))=1),((VLOOKUP(A4,'Bighorn...

Hi there, I'm stumped as to why my formula doesn't work, please help this technotard.. =IF(F9>150,"Poor",IF(AND(F9<150,>111,"Below Average",IF(F9<110,>91,"Average",IF(F9<90,>81,"Good",IF(F9<80,"Excellent")))))

I'm having some difficulty with an INDEX, MATCH, MATCH setup. I'm usually pretty good at figuring out how to make these things work after some tinkering but this one has me stumped. I have two Sheets laid out similar to the following. <tbody> NAME Recent ON Recent OFF Item 1 Item 2...

Hello All, I am fairly new to an administrative roll and am currently trying to finish an attendance track I have have started and I am stumped right now (excel novice). So basically our the two attendance rules at work are as follows; 1. You have 6 Sick occurrences to spend in a rolling...

Hi all, Here's the formula that's not working... =COUNTIF(AK52:AK35533,CONCATENATE(T$4,U$4,"??16??m1")) Stumped! THANKS for your help! Jack

This one has me stumped so I thought I'd reach out for some help. I have three columns of data like this: <colgroup><col style="width:93pt" width="125" span="3"> </colgroup><tbody> X 0 0 X 0 0 X 0 0 0 0 0 X 0 0...

I have a user who recently had to have MS Office reinstalled. Since then, he cannot run macros in the workbook which he used daily up until the reinstall. If I unshare the workbook, then he can run everything as before. I have checked add-ins and macro settings, but am stumped otherwise. An...

Apologies in advance for my PQ ignorance as I'm fairly new to its use. I do, however, feel I've combed the internet in search for an answer to my question, have not found it, and, thus, have landed here :) 1) I "Power Query" a local unedited excel corporate-provided report and begin my edits...

Hi Excel Gurus, This is my first post on a forum so I hope to provide enough info to get some assistance. I have a large table (A1:FL3259) and am trying to figure out how to automatically sort a portion of the table (Column Y:Column FL) when someone clicks on a cell in a given row. For example...

HI - I am trying to work out using the proper function(s) to achieve my desired result, but I am severely stumped. I need a spreadsheet that allows a user to make 3 decisions and have the result of those 3 decisions returned so that a formula can reference that amount to help me determine...

Hi folks, long time lurker and this forum has been a great help, but now I'm stuck, I'm signed up and hoping you can help with what should (in my head) be as easy as pie, but I'm stumped :( I have a basic 'resource required' table that tells me what various resource I need and for how long...