helper

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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