How to find the matching or nearest value from specified excel range using C#

  • Thread starter Thread starter Gani tpt
  • Start date Start date
G

Gani tpt

Guest
How to find the matching value from specified excel range using C#

I have the excel table which contains some values.

I want to get matching value or nearest value in the specified cell range

For below screen shot example,

I have the data from the range D6:I6 and D10:I10.

In the above range, i want to find and get the matching or nearest value and its column name.

If i pass the Input parameter value ==> 550

output :
then nearest value in the cell range(D6:I6 and D10:I10) is : 540
column is : H


1553881.jpg

Continue reading...
 

Similar threads

G
how to find nearest value in next column if value doesn't exist in current column linq c#
Replies
0
Views
118
Gani tpt
G
G
how to find nearest value in next column if value doesn't exist in current column linq c#
Replies
0
Views
105
Gani tpt
G
G
How do find min value based on parameter from excel range column by column using C#
Replies
0
Views
329
Gani tpt
G
G
How do we get temperature value between the range using LINQ C#
Replies
0
Views
131
Gani tpt
G
M
Bool returns true whereas one of the excel cell value does not matches to other cell value using C#
Replies
0
Views
136
Mehwish 001
M
Back
Top