Inquiry

Duwin

New Member
I have a bank of data that is updated monthly. I need to analyze said data to determine first all values above 35 then I need to look for two consecutive instances of this event. Once found, I would like to indicate for inspection if not ok
 

Michael M

Well-known Member
You may need to provide more info, but have a look at Autofilter for your "above 35"....that might also give you your consecutive instances
 
Last edited:

Peter_SSs

MrExcel MVP, Moderator
Welcome to the MrExcel board!

..can i do it in if functions?
Probably, but we don't know what your data is like, where it is or exactly what you need. Could you give us a small set of dummy data and explain in realtion to that?
My signature block below has help on how to do that.
 

Duwin

New Member
Thanks peter..

For example i have values from cell
A1 15
A2 35
A3 50
A4 20
A5 10
A6 55
A7 70
A8 65
A9 50
A10 35

In A11 the logic must be when there is a consecutive cell with values equal or greater than 35..it must say "for inspection" ..if none it must say "okay"
 

Peter_SSs

MrExcel MVP, Moderator
In A11 the logic must be when there is a consecutive cell with values equal or greater than 35..it must say "for inspection" ..if none it must say "okay"
Okay, try this. I've given an example of each result.
This is an array formula so should be entered without the {} but confirmed with Ctrl+Shift+Enter, not just Enter. If confirmed correctly, Excel will insert the {}.

Excel Workbook
AB
11515
23525
35039
42030
51025
65588
7704
86516
95032
103537
11 okay
Duwin
 

Duwin

New Member
Follow up question

Given same data

In a11 the logic must be when there is a cell with greater or equal to 35 and the consecutive cells are not yet zero, it must say "inspect" if not "ok"
 

Peter_SSs

MrExcel MVP, Moderator
Follow up question

Given same data

In a11 the logic must be when there is a cell with greater or equal to 35 and the consecutive cells are not yet zero, it must say "inspect" if not "ok"
If we have the same data how is the requirement different?

What do you mean by "consecutive cells are not yet zero"?

Perhaps we do need a couple more sets of sample data and the results?
 

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Macro to copy values across rows and transposing them and add the user id
    [FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#000000]Hi,[/COLOR][/SIZE][/FONT] [FONT=Times New...
Top