identify

Hello, I have been struggling to try and find a solution to my problem. Or if there even is any. Basically speaking I have about 50K lines of data, within this list of data I have names and amounts associated to it: Example as follows : John $30 John -$10 John -$20 John $53 Samantha $20...

Hello! I have some problem with this function that I don't know how to solve...

Hello! How to identify the first non zero cell in a row but starting from the right end? I basically need to make red the cells at the right of the above identified cell. Any hint? Thanks!

Hi there, I am having some trouble getting my code to work. I would like commandbutton1 in sheet1 to hide so it is not visible when the form is printed by the user. Could someone please help me to identify where I am going wrong with my code? I have posted it below. Private Sub...

Do have an increasing list of numbers (account numbers) in column B. I want to write a variable to identify the row number on the account first time the listed account number is above 2999999. The variable can be called "Marginrow".

Hello, Hopefully I'm explaining this well. So I've got 2 columns, or 2 cells as the example. One would have -1.5 and the other 1.5, I need to use a formula that will identify which one is the minus figure (could be in either column/cell) and then compare that minus figure to another cell. So...

Hi Excel guru's I am trying to identify (highlight) repeated numbers in a excel sheet using conditional formatting formula and try use few formulas countif , match and index but it doesn't seem to be working.. any thoughts whether this can be achieved using excel conditional format...

Hi All, I have a table showing contents, by serial #, in numbered storage boxes, which increase daily Example. Each box could have different quantities <tbody> Serial# Box# Comments A100 Box 001 Photos A101 Box 001 A102 Box 001 B100 Box 002 Documents B101 Box 002 B102 Box 002...

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

Dear All gurus, I am working on a excel file, which a bit large. I have to scroll left right to identify any negative values. Instead i am thinking if it is possible by Clicking on a button to >identify the cell having the negative value >Select the cell >Show it in message box (a message box...

I have 4 columns <tbody> MAL MQL SAL SQL SQO 1/2/2018 1:20 3/2/2018 3:30 4/27/2018 4.30 </tbody> I have a date that can be used as a reference to when a lead comes into this stage, I need to identify the gaps between the stages that will allow me to identify why a particular stage was not...

Hello, I'm trying to add some VBA code to a macro that requires I find and eliminate any zeroes that appear in a specific row (the row number will vary per spreadsheet). The row will always be labeled TOTAL LESS BREAKS in column A, so I was able to piece together this much to identify that row...

Identify the three patterns, always from the last to the next Standards Equal = E 04 04 Negative N 04 03 Positive = P 04 05 http://www.mediafire.com/file/k8gh52o9xb1ax7j/tres_padroes_igula_negativo_epositivo.xlsx

I get a worksheet every week that has hundreds of lines and more than two dozen columns. In one of the columns there's alpha/numeric numbers. I'd like to take another sheet that has just one column with these numbers. Is there an easy way to take this sheet and have the larger sheet identify...

I need to identify transaction amounts in 2 different columns as shown below, either debit or credit will have an amount. I need to identify how many transactions are below $5000, $25000, $50000, 100,000 & 200,000, so any help would be appreciated <tbody> DebitAmount CreditAmount...

I'm in the process of developing a solution using Power Query and/or VBA. For the purpose of taking any set of data (from a List Object) and converting this for interface into a financial ledger (automated journal creation). This will involve using userforms and list/comboboxes to: Map the...

I am currently trying to use a formula to identify the top 25 sales man per region in a national list. There are 2 criteria, i.e. target must be met and no red flags which i check using an IF statement. The issue Im having is that i need to limit the results to 25 salesman per region and...

Dear Team, Could you please help me to write VBA to identify duplicates and same has to highlight. Please find below mentioned table to identify following duplicates and entire row should be highlighted. Currently, I am using "CONCATENATE"(Country & Number) to identify duplicate and...

I have two groups of items which one is the master set and the second set is the subset. The subset group is missing one or more items from the master group. I need some help in writing a formula to identify the missing items. Column A has all of the items in the list; (A, B, C, CR, CRN, P...

Excel Friends, I got a large Excel workbook with too many VBA modules/procedures/functions to count. One of the sheets is governed by many macros that also call other macros. This specific sheet has one range that changes its size by populating some rows from n to m (via the user interface)...