Forum Widgets
Latest Discussions
Need help with Excel formula
=IFERROR(INDEX(TBL_REG[Appointment Effective Date],MATCH(TBL_SF[@[License '#]],TBL_REG[License Number],0)),"!-No Match") Need some help with this formula. It works fine however, in the TBL_REG table there are multiple rows that have the same [License Number] so it will return the first [Appointment Effective Date] it finds when matching [License '#] from the TBL_SF to the [License Number] in the TBL_REG table.. I would also like to match on [State] from the TBL_SF table to the [Appointment State] from the TBL_REG table. Thanks, Shane
Counting within a date range across multiple sheets?
Hi Excel community, I am working on creating a section within my grant tracking that shows us application rate per year. Until now we have mostly cared about our disbursements, but a new board wants to also examine the success of advertising our grants to the community. I have written this formula that pulls the count from the main page: =COUNTIFS('Disbursements'!K:K,">=01/01/2023",'Disbursements'!K:K,"<=12/31/2023"). This count is accurate, and for the year 2024 reads 144. I also have a sub-tracker, that tracks these same grants given to individuals living within a specific area. When I add the same criteria to the formula and it then reads: =COUNTIFS('Disbursements'!K:K,">=01/01/2023",'Disbursements'!K:K,"<=12/31/2023",'CityA'!G:G,">=01/01/2023",'CityA'!G:G,"<=12/31/2023") the answer is no longer correct. It gives me the answer 2, when it should be 170 when I select by hand. Has anyone else run into this issue before? I know my formulas could also be a little more elegant, I'm fairly new to Excel, so if anyone has any advice there I'd really appreciate it!
VBA Code for List Box Change
Hello, I'm having issue trying to setup an Excel worksheet, used as a form. Line 8 (J8, which I named the cell Question1) has a list box that is either "Please Select", "Yes", or "No". When there is a change I would like VBA code ran that deals with the selection made. If "Yes" then hide the next question, which is line 10. If the selection is "No" then just go to the next question. In the VBA editor I have top part of the below screenshot. It calls a macro, which is the second part of the below screenshot. When I choose Yes or No from the first question nothing happens besides the cell changing from Please Select to Yes or No (depending on what I change it to). What am I doing incorrectly? Thanks.How to know the original path of an inserted image ?
Hi all, I have a problem with an Excel file. In this file I used the feature "Insert image above cell" and I chose an image from a local path (on my hard drive). So far so good. However, if I copy the file to another computer, the image is gone. That's the concept. Now the problem is that this an auto-generated Excel file from an external program. I know where the images are but I generated multiple reports, modified some of the images and changed the images in some excel files to point to other folders. It works fine on the original computer but I copied the Excel files and the images (or so I thought) to the other computer and some images are missing. The question is : how do I know the original path of the image so that I can also copy it and re-link it. The additionnal question to that is : I modified the local image for some reason (didn't change the path) and I want to update the shown image to include my modification without closing and opening again the Excel file. Is that possible and how ? But the first question is really more important because basically I have a new laptop and I need to recover the whole file and images to export it if needed later in time when I won't have the old laptop anymore.
Calculating percentage of column in date range
I am trying to work out a way of calculating the percentage of staff who have completed training within the last year within a column to flag up our overall training compliance. I have already used conditional formatting stay green if in date, yellow when 90 days off date for training due and red if the date has past. I use the expiry date in the future as the entered number so if they complete today (24/4/25) I would enter 25/4/26. I am only using one column for dates so would want values from B2 to B86 to be counted and the percentage of dates that have not gone past today to be worked out as a percentage and put at the bottom of the column in B88. I also want to have a system that can have staff added and deleted as they join/leave without messing up the formula calculation if that is in any way possible. Many thanks
