cola

Good Afternoon Could someone explain (May be missing something) why the print to worksheet is in Column E <colgroup><col width="83" style="width: 62pt;"> <tbody> Sub SplitColA() Dim i& Dim Cola() As Variant Dim dict As Variant Set dict =...

I have a table which lists types of soda & the quantities on hand. I'm trying to create a dynamic list that would put each one on a new row (skipping zero quantities). It would list each, the # of time specified & then move on to the next value. The result list for this table should look...

Hi was wondering if it was possible to collate all duplicate value into new column before colA colB 1 55 1 44 1 44 2 33 3 3 4 22 4 2 5 55 after would become colA column C 1 55,44 2...

Hi, I am trying to find a way to search a large sheet of data and then sum the values based on two criteria. For example I need to return the sum of colB for each Orange in colC in the month of "Jul" colA, IE 3 in this case. The month will be expressed MMM, but colA will be as below. Is this...

Example: Worksheet2, ColA, is a list of User IDs that are created via a formula that combines data from other cells in the same worksheet. Worksheet2, ColA, is a list of IDs for existing account holders. What I did: I created a vlookup formula to confirm whether or not the new ID that is...

This index/match works perfect: =INDEX(Plan!AR:AR,MATCH(A:A,Plan!AR:AR,0)+1,1) I am looking up a sku number in ColA that exists in ColAR, but it's always 1 row below ( hence the +1 ). Next one that doesn't work for me: I want to look up same exact sku(ColA) in ColAR, but then look for a...

Hello Everyone, I think my question / problem is simple but since i am still learning I need your help. I have 2 columns (ColA,ColB) ColA = Random volume of rows with some data which repeats frequently. ColB= should pick up a sequential number 1,2,3,4 for every new data in ColA. If a data...

Hello In sheet1 i have many columns with numbers like this ColA ColB ColC 123 321 123 111 123 555 444 333 222 In sheet2 i have one column with numbers like this ColA 123 222 444 222 I want to search sheet1 for all numbers in sheet2 and remove them from sheet1, Is that possible...

I have to sheet. Sheet1 with list of values in Column A Sheet 2 has Value range as below Sheet1: COLA 1 3 4 6 8 Sheet2 COLA COLB 1 2 3 7 How do I do vlookup which will tell me all matching and non matching values from Sheet 1 and sheet 2 on both side ?

I have a pivot table that looks at supplier sales sorted descending on percent to total. Since suppliers have multiple vendor names, a particular supplier might show up as a different vendor in the pivot table. As you can see from a subset of the pivot below, Coca Cola shows up twice on the...

I have names in Col(A) and data in col(B:R). No duplicates in Col(A). Col(B) are dates Col(E:K) have data from 2017 Col(L:R) have data from 2016 I import new data (for 2017) to Col(Z:AG) After processing new data, it's transfered to Col(A:K), last row + 1 Now I have many duplicates in Col(A) and...

Hi, I have cell which contains C45-C90, I want it to split into multiple rows and fill in the form C45, C46,C47...C90 For example: <tbody> colA ColB C45-C50 0.6 C99-C101 0.5 </tbody> Expected Result <tbody> Col A Col B Col C C45 C45-C50 0.6 C46 0.6 C47 0.6 C48 0.6...

Column A are number arranged in sequence, I need a formula than can be rolled down to show a sub-sequence like below <colgroup><col width="74" style="width:56pt"> <col width="72" style="width:54pt"> </colgroup><tbody> ColA ColB 1 1.1 1 1.2 2 2.1 3 3.1...