Previous Topic Next Topic

Whatisthe formula to get higer number inexcel

Closed
jaikrish_18 Posts 11 Registration date Monday 23 February 2009 Status Member Last seen 15 April 2009 - 24 Feb 2009 à 05:17
 Jaikrish_18 - 26 Feb 2009 à 06:08
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
Related:

1 response

Réponse 1 / 1
smilezhil
24 Feb 2009 à 06:01
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....
Jai
25 Feb 2009 à 07:48
=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
Jaikrish_18
26 Feb 2009 à 06:06
=IF(EXACT(I2,S2),S2,MAX(S2:S30)) this formula is gives the Maximum highest number
for example
Jaikrish_18
26 Feb 2009 à 06:08
=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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
how to convert ounces (oz) to milliliter
JPortillo -
vcoolio -

1 response