How do i search for wide variety of values and add "S" to a Column in excel
Sorry if question is hard to understand. basically i am going through our inventory at work and i need to mark specific part numbers with an "S" in column H. is there a way to use "sheet 1 column A" as a search for in "total inv" column A"
i want to use the info to the right to search column A on the left and add an S in column H to any part number that matches
If Sheet1 is in the same workbook (which despite the picture, I assume it is), then a COUNTIF() will help.
In your Column H, Row 1 (cell H1) you can put
=Countif(Sheet1!A:A, A1)
This will count how many times the part number in cell A1 appears in column A of Sheet1.
You can see you either get a 0 or some number. So we can wrap that Countif() formula in an If() to test if it's 0 or not. If it's not 0, then we can output an S:
Update cell H1 to:
=If(CountIf(Sheet1!A:A, A1)>0, "S", "")
- How to add dynamic array formula
- COUNTIFS from UNIQUE VSTACK
- Find last used cell in Excel VBA
- Is it possible to construct an array in excel using existing cell values
- How do i search for wide variety of values and add "S" to a Column in excel
- Automatically sort a filtered dataset in Excel based on returned values in column
- Lookup from Excel database of specific dates to consecutive time series of dates
- Filter and Sort by Date, in single formula
- Countifs with and/or not working on multiple criteria
- Add Together a Set of Numbers using LAMBDA Recursion in Excel
- Extracting Date From Cells using excel formulas
- How to loop in excel without VBA or macros?
- If a number is in a range tell me the name of the range. (the value in the next column)
- Excel Lookup - Find and Compare two Columns and insert data into a third
- In Excel, my hyperlink not working to start RDP
- How do I search through a matrix for a value and return the first column of that row?
- MS excel 2016 formula for booking calendar
- How to return a value based on another value
- How to convert a month number (i.e. "12") into month name in Excel?
- Sum across multiple excel sheets with variable sheet names and cell locations
- Calculating reset in Excel Sheet
- Transpose multiple values from row to column and calculate the difference between the values
- Transpose values from row to column and calculate the difference between the values
- Copy data up until last data entry in a specific column of choice, and paste to another sheet? Is there a way to ignore Blanks when using formulas?
- Count Distinct Values in one column based on text in another column
- Using Excel rules to highlight a cell based on another cell information
- How can I change the following formula from concat to Indirect so I don't get any REF error
- Add Same Text To Multiple Cells In One Column using Excel formula
- SUM all values in a column, where cells in a second column match the cells in a third column
- Returning a value with multiple column criteria in Excel