Forum Widgets
Latest Discussions
- CN_xingApr 26, 2025Copper Contributor344Views0likes2Comments
graph
I need help creating the last graph. My computer will not format the x and y axis the way I need them to.Jess9790Apr 26, 2025Copper Contributor1.6KViews0likes5CommentsNeed 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, ShaneShaneatWorkApr 25, 2025Occasional Reader30Views0likes1CommentCounting 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!beewingApr 25, 2025Copper Contributor20Views0likes1CommentCount drop down list occurrences across multiple sheets
I have a workbook with multiple sheets from January - December, I've been trying to have my formula count every instance of a drop down selection for each sheet, but i keep getting the #NAME? error. Can you assist in finding where I made the mistake in my formula? Thank you. =SUMPRODUCT(COUNTIF(INDIRECT("'"&January:December&"'(!C:C"),"Repair"))SolvedSebaKMTAlexApr 25, 2025Occasional Reader23Views0likes1CommentVBA 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.mzeller1776Apr 25, 2025Copper Contributor72Views0likes5CommentsHow 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.Arnaud_GuittonApr 25, 2025Copper Contributor2.2KViews0likes2CommentsCalculating 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 thanks3366Apr 25, 2025Copper Contributor37Views0likes2Comments
Resources
Tags
- excel42,603 Topics
- Formulas and Functions24,718 Topics
- Macros and VBA6,408 Topics
- office 3656,025 Topics
- Excel on Mac2,653 Topics
- BI & Data Analysis2,373 Topics
- Excel for web1,917 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,635 Topics