-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
classified
-
Q
Using Multiple IF Criteria based on search on Text
Hello People, I have 3 queries and would appreciate your assistance on them: 1) I have a specific concern which I've written in more detail after these 3 listed queries, on how to write a formula which will help group bulk of text data into the desired categories. 2) Could you recommend any...- questforexcel
- Thread
- categories classified expenses formula text
- Replies: 6
- Forum: Excel Questions
-
B
Trying to assign ABC priority based on size of discrepancy
I'm tracking down some discrepancies and am attempting to prioritize them as ABC or D. I thought this would be simple but... My criteria is that if a cell value is more than 1000 or less than -1000 it would be classified as an A priority If >500 and < 1000 or <-500 and >-1000 is a B If >100...- billfinn
- Thread
- abc cell classified criteria priority
- Replies: 4
- Forum: Excel Questions
-
X
how to ignore range within defined range
Hello I have a defined range of 16 LED's but I want (i) to ignore the LED's 13-15 but still do 1-12 and 16 how can I do this? If Sheets("Intro").Range("CHOOSE_LED").Value = "CLASSIFIED" Then For i = 1 To 16 '16 LEDs- xcel50
- Thread
- classified defined ignore leds range
- Replies: 11
- Forum: Excel Questions
