float

  1. R

    Mutiple lookup, Exact and closest.

    Hello, I have some data in a table that looks like this Text, float, Result 1, Result 2 I am hoping that someone can help with a formula that will lookup the row with the closest float where the text matches. I would say it is a multiple criteria lookup where one criteria is an exact...
  2. Shweta

    Problem in changing datatype of columns with null values in sql server 2008

    Hello All, I have imported some data from a text file into SQL server 20008 R2. All the columns of the data have been imported as varchar(50). Now I am trying to change the datatype of columns using alter table statement. But the problem is, there are few numeric columns with missing values (as...
  3. K

    Worksheets floating

    I've searched the forum for this question, but only see how to stop charts or images from floating within a worksheet. The issue is that my worksheets move every which way within the frame of the window - within the column letters and row numbers. I am using Excel for Mac v15.33 and this...
    • kmeci
    • Thread
    • float move around frame not static worksheet worksheets
    • Replies: 0
    • Forum: Excel Questions
  4. V

    Float button on current row

    Greetings everyone. I have a button called "but_ENV_AVARIAS" wich runs a macro, and I need it to float on the current selected row near column I (with a fixed horizontal position), except if: - current row is above row 8 - current row is below row 30007 ...meaning, if selected row is not...
  5. L

    Floating Spin Button between Spreadsheet Tabs

    I'd like a spin button that is accessible no matter what spreadsheet (tab) I'm in. The button will be used to match columns of data with another column of data. The reason I'm trying to do this is because I cannot seem to find out how to match two columns of data... I need to match data with...
  6. V

    Check if decimal/float value is between two values

    Hi all, apologies if this has been answered as the forum software won't allow searches for the word "between"! I need to check if a monetary value (2 decimal places) is between two numbers. I've been using the usual if(and()) approach but it's sooooo clunky. I found the MEDIAN approach and...
  7. L

    Can you edit a Schema file in VBA?

    So I have a connection which is created in VBA to a text file that I have saved somewhere. I just found that there are a bunch of rows which have 0s for a certain column, but have decimals for the majority of the rest of the rows (0.5,0.6,etc), but when it creates the connection in VBA, the max...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top