1. A

    How do I use this to repeat Column n times based on number in table?

    I hope this is possible, but I want to be able to repeat column headers n times depending on the table below. I would just put the formula on the far right on the same row, but hoping it would come out like the bottom picture. Thank you if you know how to do this! Example of output:
  2. S

    Multiple Column Combibox

    Good Morning, I have a combibox in a userform that I'd like to tweak. I used to pull data from just one column to display in the box, but now I was hoping to have two columns of data (separated by a space) displaying. I've written a basic piece of code below but it didn't work. Hoping someone...
  3. B

    formatting a date

    Hello, I imported a CSV file into a query format and my date column is showing as this right now: 2019-08-28 03:32:31 EDT is there a way I can change that to read 8/28/2019? when I change format to date it does nothing. I can do a formula to pull the left numbers, middle and right but I'm...
  4. B

    Set max rows?

    Can I add a line at the beginning of my Macro to set the row limit to 5000 (or whatever)? The Macro currently adjusts for "infinite" rows and I'm hoping this will speed it up. Thanks!
  5. R

    A fix for counting empty cells!

    Hi all, I couldn't see a fix for this after doing a few forum searches, so I'm hoping you fine people can help. In column T of this spreadsheet I have put a formula in [ =(COUNTA($E6,$H6,$K6,$N6,$Q6)-COUNTIF(E6:S6,0))/COUNTA($E6,$H6,$K6,$N6,$Q6) ] which counts the amount of times text is...
  6. leopardhawk

    Formula where value cannot be less than zero

    This formula works for me except that if 'oas recovery tax'!D5 is greater than a certain threshold, in this case 125650, then it is returning a negative amount. I am hoping that there is a modification to the formula that will ensure that it never returns a value less than 0 (zero)...
  7. B

    Custom Format- Feet & Inch

    I was wandering if it was possible to have a cell that when you entered 240 and hit enter it would show 240 (20')? I was hoping this would be possible with the custom option in the format cells dialog. Thanks for the Help.
  8. S

    debug print help

    If I wanted/hoped to have a screenshot of the exact error (specifically the highlighted line) of code and to save it in a file on my desktop. I am not exactly sure how to do this and was hoping I could get some help. Thanks!
  9. I

    Paste each cell 12 times

    Hi I have list of accounts and I need each account to be pasted 12 times. So I need to transform Column A into Column B. I have 1600 accounts so I was really hoping not to do this manually :))
  10. V

    Find & Replace based on a Cell Value

    Hi guys, I don't work in VBA too often and have been searching for hours for, what I thought would be, a simple Find and Replace code. All I'm trying to do is search for a cell's value (located in "B8") down a column ("B14":B"). If a match is located, I was hoping to replace that matched row...
  11. U

    Adding one row to a Sum function

    I wrote a function that scrapes data from a web site and adds one row just above the TOTALS row. That row has a sum function that for this example is: =SUM(B121:B137) But once I add one row it should be: =SUM(B121:B138) I have a LONG process in mind to address this but I am hoping there is a...
  12. F

    Text to Columns Formula

    I'm hoping someone can help me with splitting a column of data into six separate columns. I've tried using various functions with no luck, as the numbers can be different lengths, although each are separated by a forward slash. The "Text to Columns" feature isn't really an option as I'm hoping a...
  13. S

    Comparing 2 Lists and using Vlookups with multiple rows.

    https://drive.google.com/open?id=1TfqRi0g6FwDCY0iNOfVWOyLhAXgBPygR I'm trying to write a VBA sub to look up the value of two references on different sheets. The problem I've got is the value being looked up has entries in more than one row which I believe is difficult for this command. I was...
  14. B

    INDEX / SMALL / (match?) partial lookups, multiple criteria

    Having no luck getting my head around the order or events and hoping it's easier than I'm making it out. Two columns- column A is a list of names; column B is either a numerical entry or "tbd" for 'to be decided. Want to put out a list of names where the first two characters can be the "tb" in...
  15. E

    Show Cost Year

    Good Afternoon All I was hoping you could help with the below example, which I'm sure is fairly simple but I'm not sure where to start <tbody> 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 Recommended Year 6640 0 0 0 0 0 0 0 0 0 2019 </tbody> I was hoping to use a formula in the...
  16. N

    IF only...

    Hello Everyone, First time poster and hoping you clever people can help me with a formula that seems beyond me. My formula is as follows: =IF(A2<"","In Progress",IF(A2="","Dormant",IF(F2="","Complete"))) So if A2 is empty it is "Dormant", if it contains anything it is "In Progress", but it...
  17. N

    Auto Search Filtering

    So I am sure everyone or most people now how auto filters work. I was looking into, I guess dynamic searching. So as you type in what you are looking for it preforms an autofilter. I was hoping someone would be able to explain how to do this, as well as, is it possible to have two of these on...
  18. C

    Get and Transform - changing/finding value if blank

    Hello, I hope everyone is well. Long time, no post :) I receive non-normalized data from our field staff who are in teams of 2. For our final analysis, we choose only the team lead (indicated in its own field/column as TL). However, on rare occasion, they leave their response blank and we need...
  19. B

    HCL Leap Expert Needed

    Are there any HCL Leap experts out there? Doing a survey and have a question about creating a table for a question. Able to put it together, but when we save and go into the survey, the formatting is all gone. Hoping to maybe talk to someone that can walk me through it. Thanks! Bob
  20. Trevor3007


    Hi I am trying to cut down the amount of inputting on a time\expenses workbook . The cell (d34) is a date and I was hoping to trigger the cell to autofill based on another cell if it was >0, (cell ref Timesheet!D33) , it would look to Timesheet!B23 (which is a date) and as d34 is in the...

Watch MrExcel Video

This Week's Hot Topics

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