col2

I have a tbale similar to below and i need get results which show how many non blank values in col2 for each unqiue value in col 1 <tbody> col 1 Col2 1 1 2 a 2 b 2 c 3 3 4 a </tbody> The results i would like are: <tbody> 1 0 2 3 3 0 4 1 </tbody> Does anyone...

Hi I have an excel sheet with Columns Running from 1 to 150 - First row is header Example <tbody> Col1 Col2 Col.... Col120 Col130 Col150 principal@alphass.eq.edu.au 0517_PandC@eq.edu.au EQInternational@dete.qld.gov.au nmcca106@eq.edu.au accounts@helpinghandsnetwork.com.au...

I have a data with various combinations (Sample illustration below) where values in col1 and col2 reverses and therefore reports. I am looking for a way flag the reversed duplicates (A-->B and B-->A are same to I just want to keep one record) and ultimately delete the duplicates (#3 and #4 )...

I have the following macro to write the value in column 1 based on the available value in column 2 and 3 Sub ColumnValue() Range("A18").Value = "=IF($B$18=0,0,1)" Range("A19").Resize(Cells(Rows.Count, "B").End(xlUp).Row - 18) = "=IF(C19=1,A18,IF(C19=0,A18+1,""""))" End Sub But I want...

if all 4 qtr is >= 100 then 20000 , if any 3 qtr > 100 and anl > 105 ach% , then 20000 after matching col1 and col2 with the grid <tbody> grid col1 AA A B C ANL XX 25000 20000 16500 13000 105 YY 20000 17000 14500 12000 110 data col1 col2 QTR1 QTR2 QTR3...

I have a series of tables on a worksheet, indentical in layout, and I need a VBA function to use a LOOKUP function for any of the tables sent to it. Simplified, the tables look like this: <tbody> Table1 Table2 id col1 col2 id col1 col2 1 a d 1 u x 2 b e 2 v y 3 c f 3 w z </tbody>...

In Power Query, I would like to perform transformations on certain columns that are dependent on the value in another column. For example, in this table, <tbody> Value Col1 Col2 Col3 Col4 A aaa 123 456 789 B bbb 123 456 789 C ccc 123 456 789 </tbody> On any row...

Dear All, I have a table with 26 Columns and 2045 Row, I need to add rows with the same exact data but depending on the number available in COL2 meaning: If I have number 2 in COL2 then I need to add ONE row with the same exact data except having COL2 for the new added rows is BLANK If I have...

Hi I have data in two spreadsheets as below Sheet 1 Col1 Col2 AAA 01 BBB 02 CCC 01 DDD 03 Sheet 2 Col1 Col2 01 X11 01 X12 02 Y11 02 Y12 02 Y13 03 Z11 I want to match col2 in sheet 1 with Col1 in sheet2 and whenever a match happens i need...