# Solved I need help with a formula

Microsoft Excel 2010 - complete product...
February 23, 2016 at 07:55:40
Specs: Windows 10
 I have a spread sheet with a list of filters sorted by their max CFM rating. I want to type a CFM rating into B4 and have C4 tell me what filter to use.

See More: I need help with a formula

February 23, 2016 at 10:10:02

#1
February 23, 2016 at 08:29:36
 I'm not sure what you mean.I have a spread sheet with a list of filters sorted by their max CFM ratingAre you talking about Excel filters?How are you using the filters?Are you using them to simply sort your data?I want to type a CFM rating into B4 and have C4 tell me what filter to use.Not knowing what CFM means, I'm not sure there is a way to return an Excel filter, unless there is a VBA solution.Unfortunately, my crystal ball is out for repair this week, and from where I'm sittingI can not see your spreadsheet, so I have absolutely no idea what it is your trying to do, unless you explain it in more detail.Also, you asked another question, and DerbyDad03 answered it with a few of his own questions.Is your previous question related to this one?MIKEhttp://www.skeptic.com/

Report •

#2
February 23, 2016 at 08:44:03
 No. Filter as in Air Filter. (which makes googling a pain in the A). CFM= Cubic feet per minute (How my filters are organized. Right now I am using a match and a VLOOKUP but it is not quite working the way I need. My filters are in order from the lowest CFM rating (35) all the way to the highest (7500)I would like to type in any number as a CFM and it give me the filter that is best rated. the formulas I am currently using are populating the cells.... but if I type in 36 it will still give me the filter that MAX's at 35. Does that make any more sense?

Report •

#3
February 23, 2016 at 08:53:24
 My guess is that the filters he refers to are air filters or maybewater filters, since "CFM" is a widely-used initialism for "cubicfeet per minute", a standard measure of flow. You see it usedin specifications for cooling fans, for example. SnoopDoug must have a list of filters with various flow ratings.He seems to want to type a number into one cell, and have thespreadsheet program output a subset of the list which haveflow capacities that match his input. I would expect that if hehas a decent selection of filters, there will usually be severalwhich have a capacity equal to or greater than the input value.He will still have to choose among them. It has been a while since I used Excel, and I don't know how todo formulas or conditionals in it. -- Jeff, in Minneapolis

Report •

Related Solutions

#4
February 23, 2016 at 08:55:18
 Must type faster. :-) -- Jeff, in Minneapolis

Report •

#5
February 23, 2016 at 08:58:12
 Thank You sir. It is extremely hard to verbalize excel issues. But you are correct. The issue I am having now is that it will give me the Air Filter rated for 35CFM when I type in 36CFM. Until I enter a number higher than the next filter which is 75CFM. I would like it to give me the 75CFM filter when I type in any number exceeding 35 and so on.

Report •

#6
February 23, 2016 at 10:10:02

Report •

#7
February 23, 2016 at 11:00:25
 Thank you for the help. I am going to work on this and I will let you know how it goes. You guys are awesome

Report •