colb

Hello excel guru's So from row 18 to Row 24 I have a transaction listing going across many columns and within ColB on those rows, I have values like this: -7.73 -27.57 5.52 12.40 -4.14 266.54 -42.40 From Row 60, I would like to populate bits of data from these transactions but only from the...

ColA ColB 4 1 3 2 2 3 5 3 2 3 1 2 A20 B20 17 14 Sum ColA and Multiply by 3 (17*3) = 51 Sum ColB and Multiply by 2 (14*2) = 28 Then I need to add those 2 values (51+28) and...

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

Good Morning all.... Got an odd one in that what I have is working, just not well.... I have a sheet with two columns and 100k plus records Col A contains a text description that is fetched by a VBA Cut and Paste from another sheet. In ColB I have automated a COUNTIF to copy from Row2 down...

hello, I have 2 columns of dates I want to find the number of business days ( ignore holidays) between ColA + ColB then add the number of days resulting back to ColB ( date or cell No ) to show a future date I used networkdays to get the difference but can't get the rest...

Such as Col A a a b c c e k k e I need result in column B (duplicate value is not my concern, just jump to next different value) ColB: a b c e k e