working

Would anyone be willing to look at it for me and try to solve why it's not working right?? Would be happy to email it for help!

Hi, I am using conditional formatting with the formula =IF(ISERROR(MATCH(Q4,Sheet2!$A:$A,0)),FALSE,TRUE) with range =$Q$4:$Q$2000 but it only works until cell Q216 and doesn't format anything after that. I have no idea why it's not working, can anyone help? Thanks

Hey guys, can someone tell me please why this file is not working? https://sheet.zoho.com/sheet/editor.do?doc=2f316a5f957451ed09ebbb4a127947ccf5a1467f845cffe4c8a8094a66592afeb433327fda0a94208330b6f8e188e67294c4ed9a2e62d8dd325f910d1a209e47 am using (...

Hi, I'm trying to come up with a formula that calculates how far we are through the year in percentage. Right now I have: =YEARFRAC(DATE(YEAR(TODAY()),1,1),TODAY()) But I'm not sure it's working properly. Any ideas? Thanks, Mark

Hello forum friends, this formula below is working but it is also including data for 2020 and 2021 which are both currently 'blank'. =AVERAGE('2018'!I257,'2019'!I208,'2020'!I257,'2021'!I257) I tried the following and I am getting an error ("You've entered too many arguments for this...

Hi Guys, Hope you can help me with a very annoying problem. I'm working on a project and receive around 1,000 .xlsm workbooks each week that I need to edit and save. The problem is the person who is sending these workbooks inserted a VBA code on each that goes like this: Private Sub...

Hey Dear community, I have problem with following formula This is working formula sum(if((isnumber(match(rn,mrkt,0)))*(sfs>0)*(urun<>"""")*(not(isnumber(match(mstr,by,0)))),printed)) But this one is not working...

Hi people, I had an issue with recent update PBI desktop, where Bing maps are not loading in my visuals and I can see same visuals working in June updated version. Does anyone else facing same problem with the recent update of PBI desktop? Can anyone help me to solve on this or any...

This is duplicate! I have Microsoft Office 365 2019. How can i add some <code style="margin: 0px; padding: 1px 5px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console"...

Hi all, again. If I can't do the simple thing, I will NEVER ever stand a chance at learning how to correctly code. Ok. There's a form that loads when a spreadsheet is clicked; Private Sub Worksheet_Activate() CustForm.Show End Sub This form has 4 command buttons. One of these buttons...

Duplicate link here! How can i add some `button` or `menu` or `gallery` here ? This `XML` code not working! Please help! (if i add the `Shapes` at the end it's also not working!). <!--?xml version="1.0" encoding="UTF-8" standalone="yes"?--> <customui...

Hi!!! I'm working on a data base where I need to link cells to another sheet, but its not working and i keep getting the "Cannot open the specified file" message. Even the simplest way using =HYPERLINK('Other sheet'!A509) When i use de manual option "Ctrl+K" it does work. But I need to link...

Hi, I’m not sure if anyone can help me? I’m trying to write an excel query and have gotten completely stuck. Scenario I’m wanting to write a query that looks at data and gives a response based on the data it queries. It’s actually for fault finding fixed assets for lighting. If we have...

Dear Expert I have to filter my worksheet quite frequently on the basis of value in the last cell of a column. Please help me form a vba for that. I'm sharing the amount of work I was able to do... Thanks a lot ? Range("Visits[[#Headers],[Sr]]").Select Dim varSr As String...

Hi experts, I am new to VBA and very keen to learn but unfortunately I am working on a massive project at the same time so learning curve is steep. I think it is normal to post attempts at code when asking for advice, but I have no idea where to start with this one. I am basically working...

Hello guys, Can you help me with this one, I need to pupulate the 'calendar' with the same task that is due on 'each specified working of the month' ie, every 4th working day is x and every 15th working day is y... At the bottom of the table I have left the 'numbers' in as they show the NEXT...

I'm sure you've seen this subject before but I am pulling out my hair. Excel is getting worse and worse at hanging while I'm using it. I'm using Office 365 with a Windows 10 PC, stand-alone. I'm also using OneDrive and just a hunch that it is playing a part in what's going on. BUT it will also...

I need help with a formula please to calculate the number of working days between two dates, I'm not sure how to use the WORKDAY function or even if that's the correct way to go.

I have a massive spreadsheet of people and their qualifications. Vlookup will only return their first qualification on the list, but I need to know each one by line. I’m trying to use an “IF AND” statement. So, if column 1 contains the persons name and column 2 contains qualification name 1 (at...

I have two tables one of them contains a particular's distinct values as a primary key. and another table consists the same particular's multiple values for different dates along with few more details. now based on some conditions i want to bring the outcome count to the first table for further...