searched

  1. J

    Return multiple values in one cell from VLOOKUP

    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...
  2. F

    count blanks and non blanks same formula

    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...
  3. S

    INDEX / MATCH / OFFSET / AVERAGE Formula

    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...
  4. SimonHughes

    Error message on opening

    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...
  5. H

    Need to auto calculate positive or negative value in list

    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...
  6. D

    Shift name based on timestamp

    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...
  7. M

    VBA to Remove Leading Space

    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.
  8. S

    Getting macros to function in MS Teams???

    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...
  9. C

    Another method to speed up SUMPRODUCT

    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...
  10. Ironman

    Internal workbook link checker?

    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!
  11. O

    VBA requirement for searching string that begines with...

    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.
  12. P

    Icon Arrows

    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
  13. L

    2 form control drop boxes, i want them to move simultaneously

    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...
  14. B

    Get all file names and list in a worksheet with VBA

    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...
  15. I

    Count Help - a column of different dates I need to compact into how many of each date exists

    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...
  16. S

    Excel macro to organise files

    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...
  17. E

    Getting data from many sheets to one overview

    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...
  18. R

    Name Manager does not open

    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
  19. M

    Help with VLOOKUP with OR

    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...
  20. G

    Cannot select all the blank cells due to a ' in the formula

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top