helper

  1. R

    Runtime Error 1004 - Using VLOOKUP in VBA (COMPLETED)

    Running a very basic test code to try out on a large amount of data, but having trouble, getting the "1004" error. Sub HugeSort() Dim c As Integer 'LOOPS THROUGH ALL ROWS For c = 2 To 10 If IsEmpty(ActiveSheet.Cells(c, 1)) = False Then ActiveSheet.Cells(c, 2) =...
  2. B

    COUNTIF with an AND

    Data set Col A A A C Col B J K J I want a function that will do this:=COUNTIF(A1:B3,AND(A1:A3="A",B1:B3="J")) and in the data set above, the COUNTIF would return 1. I know that I could add a "Helper" column in Col C that has =AND(A1="A",B1="J") and put a =COUNTIF(C1:C3,TRUE") but I don't want...
  3. N

    average of non-numeric cells without helper column

    Hi there, I am trying to identify a mismatch based on non-numeric data in a spreadsheet but unable to do this without a helper column that converts it to a numerical value. It seems like there should be an easier way to achieve this (without the helper column) but I gave up searching for it...
  4. S

    Extract unique values from multiple columns based on a set criteria to create a running list

    Good day, I have been working to simplify a log that is used by a lot of people I work with. I originally built it years ago with helper columns and need to get rid of them. I have 2 items I need to solve but will post the second one in a different post. Item 1: I have a massive log, column B...
  5. K

    Returning an array of sums without any helper column

    We have n positive integral "random" values in n consecutive rows in a column with only the n-th value always as 0. Is there a formula which would return in a particular cell, without any helper column/row/cells, an array where the p-th term is the sum of the first p terms of the original set of...
  6. S

    Error Checking

    So I've written this error coding. I was hoping someone could check it over and tell me 1. why userform18 won't show when running and 2. Is there coding I can put in userform 18 that would allow me to "screenshot" a highlighted string of code (the code that error'd) and screenshot (or save as a...
  7. T

    Excel "helper" no longer appearing

    Hello The helper or guide for excel no longer appears. For instance in the past I would be typing code and a "helper" would pop up. In a module, If I entered Columns. a drop down box with all the available choices would appear. Or if I entered Columns.Find( the properties needed for each comma...
  8. M

    Multiple conditions

    Thank you for resolving my request. Excel 2007. Now alternatively, I want to improve the SAME database with helper cells. Col C5:C84 contain dates dd-mm-yyyy Col D5:D84 contain amount in numerical Col E5:E84 contain dates dd-mm-yyyy Additions: In addition to my database in C5:E84 as above, I...
  9. A

    Excel Challenge from a friend - I failed can you solve it?

    I hope one of you gurus can solve this. I was only able achieve right result using 2 helper columns but challenge requires only 1 helper column to be used (part 1) and no helper column at all for part 2 of challenge. I managed to get the correct answer of -111 using the following formulas in...
  10. B

    Reverting back to Original Column Sort order

    Is there another way of reverting back to the original column sort order other than adding a helper column with the original sort order (without using VBA, of course) Jon, from Excel Campus, posted a video today on this topic (he is describing the helper column index method in his tutorial)...
  11. J

    Formula to group values based on above cell?

    Hi, Didn't know how to word the title, I have data in the following format: 00100 | A1A 00101 | 00102 | B6A 00103 | B9H 00302 | A7R 00403 00404 00309 | B8R 00408 | E7S I need an helper column (C) to fill down the B column values Example: 00101 = A1A 00403 and 00404 = A7R There is sometimes...
  12. S

    Help indicating if a 1 or 2 is present

    Hi there. I have a helper cell that has 1's attached to a job profile number. If an employee left or was transfered I have a 2 next to that job profile number. What I am looking to do is create a helper column that will determine whether the column to the right (B) job profile has 1's and 2's...
  13. R

    Update formula to include cells?

    I have a column of dates that will be added to over time and include duplicates. I need to extract unique dates from that column to create a dynamic list. To that end, I created a helper column (Column F) to display a 1 for when each date first occurs in the column; if not, then 0. <tbody> A...
  14. M

    Shorten list in a Dropdown (data validation) list

    I have a very long list of people I need to select from and have set up a way to shorten the list by typing in a few letters and then hitting the dropdown box to see what matches. Works well. My question is... it seems the worksheet needs to be unprotected for this to work. Is this correct...
  15. C

    Index/Match formula for specific date range?

    My sheet https://drive.google.com/open?id=1GoH102qo7XEY1pOD2x_Bvw9fkzPezLQ-. I really need you help guys. My problem is in my summary sheet I want to appear the PRN cell M3 if it has color within the specific date entered in J3&J7. Like the data I entered. I used helper sheet for my conditional...
  16. M

    Adaptation of formula without helping columns

    Hello,</SPAN></SPAN> The formula I am using for that in need to have helper columns gives result in column "K" as shown below</SPAN></SPAN> Book1ABCDEFGHIJKL123n1n2Joinn1n2JoinLast Row Number4313 | 1111 | 1235858 | 5121 | 2296313 | 1131 | 3157525 | 2141 | 4278222 | 2151 | 59686 | 8161 |...
  17. R

    Array Function with Dates

    Hello Excel Experts! I've got a column of dates, formatted as Day, Date, Year. And, I'd like to count all the Sundays using an array formula (like countif) So, Sunday, January 6, 2019 Monday, January 7, 2019 Tuesday, January 8, 2019 etc. It's easy as pie to create a helper column, just...
  18. DRSteele

    Identify rows where value exceeds hurdle consecutively

    Can someone please help me? I need a formula for the red column. I wish to identify the rows where the Value equals or exceeds 20 and is part of a streak of at least 4 rows where the Value equals or exceeds 20. Here I used 1s and 0s in a helper column to identify the desired result. Eventually...
  19. Sean15

    I want to get rid of helper column in SUMIFS formula

    Hello: I have: Dates in column F Negative/positive numbers in column V Helper column AB is for the month of the date (10/1/17 = 10, 5/31/18 = 5) The SUMIFS formula below give all the required values: =SUMIFS($V$2:$V$5000,$V$2:$V$5000,">0",$AB$2:$AB$5000,AD25) I want to get rid of the...
  20. Navi_G

    Date Box For Date Selection and Data of Table 2 required in Chart

    Hi, i am working on active x control and chart but i need true guide lines. i) In spread sheet i need to a Date list Box (Active x control) for date selection like 12-Mar-2018. ii) In Second thing i need to select in chart (Bar Chart) From Table 1 and Table 2. Illustrations: <TBODY> Table...

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