Whatisthe formula to get higer number inexcel

[Closed]
Report
Posts
11
Registration date
Monday February 23, 2009
Status
Member
Last seen
April 15, 2009
-
 Jaikrish_18 -
Hello,
Hello,
i'm jai krishnan im having a big problem in excel
1. in column A i'm having set of numbers in Column B also Having some set of numbers.
Now the result is first it has to match the numbers if no matches the the result should higher numbers Examples
Column A
10
20
100
900
1010
75
Coloum B
15
20
956
1100
95

Now matchfrom Column A
First Row 10 is there no match in Column B So next higher numbers is 15
Second Row 20 match20 is there in Column B so result will be 20
Third row 100 match100 no hundred inColumn B next Higher number is 956 like this i'm having around 35000 Rows So i want the result i want so pls tell me what is the Formula i can use to get the result.pls tell me the Formula
Thank U
Jai

1 reply

Hi,
This is the solution for your question now i am comparing the data in A1=100 and A2 = 200 and the result i write in C1 = =IF(EXACT(A1,B1),B1,MAX(A1:B1))..

hope this solves your problem....
=IF(EXACT(I2,S2),S2,MAX(S2:S30)) this formula is gives the Maximumnext highest number
for example
ColumnA
900
1250
1350
1721
2160
2304
2651
2730
2888
2925
3432
4200
4212
5312
Column B
290
870
4260
3089
6177
16060
32120
28116
56232
37488
56232
123710
84348
168696
112860
37062
74124
like this in A&B column not this much around 50000 rows data are there from this
iwant to check next higher number not the maximum higher number the above formula is giving the next highest number.Idon't want that i want next higher number Column A Row 1 is 900 in column B next higher number is 3089.for this what is the formula pls pls any help me in this issue i'm struggling fro more that 10 days.so pls help at the earilest.
try in Excel past the 2 column numbers and check then give me the formula
Thank U
Jai Krish
=IF(EXACT(I2,S2),S2,MAX(S2:S30)) this formula is gives the Maximum highest number
for example
=IF(EXACT(I2,S2),S2,MAX(S2:S30)) this formula is gives the Maximum highest number
for example
ColumnA
900
1250
1350
1721
2160
2304
2651
2730
2888
2925
3432
4200
4212
5312
Column B
290
870
4260
3089
6177
16060
32120
28116
56232
37488
56232
123710
84348
168696
112860
37062
74124
like this in A&B column not this much around 50000 rows data are there from this
iwant to check next higher number not the maximum higher number the above formula is giving the next highest number.Idon't want that i want next higher number Column A Row 1 is 900 in column B next higher number is 3089.for this what is the formula pls pls any help me in this issue i'm struggling fro more that 10 days.so pls help at the earilest.
try in Excel past the 2 column numbers and check then give me the formula
Thank U
Jai Krish