Comparing Column values with a constant

Closed

vikram - Jul 27, 2010 at 03:17 AM
Blocked Profile - Jul 28, 2010 at 06:53 AM

Hello,

How do i compare the column values with a constant.I have a column named 'STATUS' that has values like 'A' 'S' 'D' etc. I want to proceed only if any of these values is 'D'.
I mean it should compare one by one all values & proceed if the value comes as 'D'

How do i implement this using macros?

Thanks,
VIkram

Comparing Column values with a constant
Excel copy column from one sheet to another automatically - Guide
Excel count how many times a value appears in a column ✓ - Office Software Forum
Based on the values in cells b77 b81 ✓ - Excel Forum
Comparing columns in two different excel sheets and if they match copying third column - Excel Forum
Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array ✓ - Excel Forum

1 response

Answer 1 / 1

Blocked Profile
Jul 28, 2010 at 06:53 AM

Dear Vikram,

Please have the solution from the below link.

https://ccm.net/faq/7170-excel-comparing-column-values

Thanks.

Similar discussions

help me to add particular cells

Auto generate serial number in excel based on Column

VBA find column by name and sort

Converting rows of data in notepad to columns

How to copy the Column value into Rows

Similar discussions

Subscribe To Our Newsletter!