searched

Hi, I am using this formula =CHOOSE(SUMPRODUCT(--(B11=A1:A8)), VLOOKUP(B11,A1:B8,2,0), VLOOKUP(B11,A1:B8,2,0) & ", " & INDEX(B1:B8,MATCH(B11,A1:A8,0)+1), VLOOKUP(B11,A1:B8,2,0) & ", " & INDEX(B1:B8,MATCH(B11,A1:A8,0)+1) & ", " & INDEX(B1:B8,MATCH(B11,A1:A8,0)+2)) to return more than one...

Needing a formula to count non blanks in 1st column and blanks in the 2nd column. So the example it would count 2. the text is giving me issues trying to do a COUNTIFS formula and using COUNTA formula. I've searched and tested but nothing is working for me. appreciate any help in advance...

Help me Guys... <colgroup><col span="10" style="text-align: center;"></colgroup><tbody> DIV DOI 55555 33333 11111 44444 22222 66666 77777 888888 104 11111 10028 10128 10240 10358 10520 10748 10867 11583 104 22222 6948 7024 7099 7174 7245 7364 7440 8562 104 33333 1051 1200 1280 13523...

Hello, I am getting an error message which states "Sorry, we could not find C:\Users\Simon\Downloads\QuotesAddIn64.xll. Is it possible that it was moved, renamed or deleted"? This file was for an add in that I unsuccessfully tried to install. I have searched my PC for the file without...

Ie:daily usage is mixed and can vary from zero to 1000 I cant work out how to automatically show negative or positive % variance from a median number (Say 470) I admit i struggle with excel and come to you with hope that you can help.:confused: I have searched online and much of it does not...

Hello I am trying to get a shift name based on a timestamp in a different cell. For example if my timestamp says "6/19/2019 13:41:37" I want the word "First" to show up in the next column to identify the shift name. I have searched and searched for an answer to this and cant seem to find it...

I am not well versed on macros and am looking for assitance on a VBA that would remove/trim leading spaces. Cell range is A1:AU500. I've googled around and searched the boards here, but I can't quite get anything to work. Thanks for your help.

Hello All, If there is a technique for enabling macros in Microsoft Teams, please tell me. I developed this shift pass-on macro filled workbook, and now my employer wants to upload it to MS Teams, and of course all of the macros are disabled. I searched the Forum here and am surprised that...

Hi guys, first time poster, long time lurker. First of all I want to thank you all for your awesome contributions. Thanks to you guys my vba skills have improved and I was able to find solutions to many questions I had in the past. Having said that, I've searched and searched for the...

Hi I have hundreds of links to other sheets in the same workbook and I'm looking for a quick way of identifying broken links without me having to click on every single one. I've searched the forum and I'm only able to find code for checking external hyperlinks. Hope you can help? Thank you!

Hey all, In need of a simple code that will search string in Column A that begins with "BEL" . Once searched goto target.row. Will appreciate any help. Thank you.

Hell o, As the Conditional format shows icons for arrows, but the Red points down and the Green points up, is there a code that can change the arrows, so that the Red points up and the Green points down? i have searched and am not able to find anything suitable Many thanks Pugg

I have 2 drop boxes. They were created with the developer insert, form control and i have them linked to graphs whcih update upon changing the option in a list. i am using a Choose(cell, list name, list name etc....) Each drop box referneces the same list of items but the results differ as...

Hey All, I'm using Office 365 and trying to write a macro that lists all of the excel file name in the directory "C:\Users\[username]\Desktop\49" into a worksheet I used to have a macro that did this but can't find it now and I've searched online and found a few that use filesystemobject but...

Hello everyone, first time poser. I read the FAQ and i searched and searched but I could never get the words right to get the answer. I have a column of cells with a range of dates and times: for example: <colgroup><col></colgroup><tbody> 5/11/2018 8:22 5/15/2018 8:24 5/18/2018...

Hi, I have some files in a folder. These files to be copied to different folders. Example : List of Files in Folder A : 20170725_011111_G113_17_ACC.pdf 20171125_001011_I002_17_ACC.pdf List of Folders in Folder B : 001011_InternalMicrometer 011111_ExternalMicrometer...

I have searched the Internet and, ofcourse, this forum. I just could not find a workable solution (maybe I haven't searched good enough). What I have is a workbook with 200 sheets with exactly the same layout. It is a working schedule of 200 employees. What I want is in a specific sheet to...

In an Excel 2013 workbook when attempting to open Name Manager (Formulas > Name Manger) I receive the progress circle for a few seconds than nothing. I have searched the forum and internet with to luck. Anyone have ideas? Thanks Ron

I would appreciate some help with a VLOOKUP syntax issue I am trying to add another condition (OR) to my existing formula The formula below works correctly =IFERROR(VLOOKUP(H9,Table!A:W,23,FALSE),"") I want to expand it to look at both H9 or F9. Is there a way of doing this? I searched the...

I have got the following problem. When the cell values appears blank (e.g. at B2) there is still the value ' in the fx bar. I want to select all the blank files, but due to this problem I cannot do that. I searched on how to solve this, but I cannot find any answer unfortunately. Anyone...