Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by ArisaAnsar
at 2024-07-17 13:56:41
ModifyPoint:500 Replies:5 POST_ID:829011USER_ID:11913
Topic:
Microsoft Excel Spreadsheet Software;;Visual Basic Programming
I have a large file with over 65000 rows. For each row, if there is a "Y" in any cell of columns E, F, G, H, I would like to add a a value of "OK" in column J.
Do you know of a formula that will do this?
Do you know of a formula that will do this?
Attachment:SAMPLE-EDEL.xlsx
Expert: duncanb7 replied at 2024-07-17 15:21:42
Thanks for your points
Have a nice day
Duncan
Have a nice day
Duncan
Author: ArisaAnsar replied at 2024-07-17 15:15:10
Thank you! All of this worked great. I really appreciate it.
Assisted Solution
Expert: duncanb7 replied at 2024-07-17 14:44:15
166 points EXCELLENT
on Excel cell J2
you can do this =IF(COUNTIF(E2:I2,"Y")>0,"OK","")
on VBA,
you can do this
you can do this =IF(COUNTIF(E2:I2,"Y")>0,"OK","")
on VBA,
you can do this
Sub test() Range("j2").Value = "=if(countif(e2:i2," & """Y""" & ")>0,""OK"","""")" Range("j2").Select Selection.AutoFill Destination:=Range("j2:j6000") End Sub 1:2:3:4:5:
Accepted Solution
Expert: T.J. Couey replied at 2024-07-17 14:08:48
167 points EXCELLENT
This should do it....
=IF((COUNTIF(E1:I1,"Y")),"OK","Not OK")
=IF((COUNTIF(E1:I1,"Y")),"OK","Not OK")
Assisted Solution
Expert: duncanb7 replied at 2024-07-17 14:08:23
167 points EXCELLENT
At J2 put
=IF(COUNTIF(E2:I2,"Y")>0,"OK","")
and drag the cell down to the row you want
Duncan
=IF(COUNTIF(E2:I2,"Y")>0,"OK","")
and drag the cell down to the row you want
Duncan
