nice

  1. V

    Turning 1 workbook link into a table

    I have 200 links to different workbooks that I need to turn into tables/data. =+'https://onedrive.com/Documents/[File1]Sheet1'!E1 =+'https://onedrive.com/Documents/[File2]Sheet1'!E1 =+'https://onedrive.com/Documents/[File3]Sheet1'!E1 ... =+'https://onedrive.com/Documents/[File200]Sheet1'!E1 I...
  2. B

    countif question

    Good Morning, and thanks for the help. I am working with a string of 169 grades (numbers), >90, <70, 80-89, 70-79 I am good with countif on the >, < but need help with those two ranges. Is countif the best formula to use, and if so how to i use it for the ranges, and if not what would you...
  3. I

    Macro etc to select entry in drop down list

    Hi, Is it possible for a simple code for which when the worksheet is open the first entry in the drop down list is selected. have a nice day.
  4. X

    Help with formula

    hi all i have got this far with the formula =IFERROR(VLOOKUP(B8,P8:Q1265,2,FALSE),"ERROR! ") I would really like to not show the "ERROR!" until there is a number in Cell B8 is there a way to do this? Hopefully i have explained what i need lol (Trying to learn so please be nice lol) Thanks...
  5. S

    Following

    Is there a way to tag a post to follow? In other words, it would nice to be able to refer back to see what the resolution to the issue was. Thanks!
  6. RobbieC

    zooming and centering a range...

    Hi there, I have a macro to auto zoom to a range when someone enters a sheet as this is where all the input fields are: sub enterSheet() ActiveSheet.Range("T1:CZ1").Select 'set range zoom ActiveWindow.Zoom = True end sub Is there an extra bit of code that I can slide in there to center this...
  7. M

    Using CountIF in VBA - Something wrong with range - 1 row of code only

    everynumber = Application.WorksheetFunction.CountIf(Range(“A1, AD1000”, ">0")) Hi! It just doesn't work, I tried everything to get along with this CountIf Function but I just doesn't succeed. Could you help me out please? Have a nice day!
  8. I

    Excel Cell common Text

    Hi, I am trying to find the common/repeated text in Cell A2 AND Cell B2 and show the results in Cell C3 Eg: Cell A2 Nice Job, agent 104 Cell B2 Great and nice, but what about 106 Result Cell C3 nice Referred some of the posts but they compare with the whole column which is not required...
  9. P

    request for help

    I have a series of numbers in a cells in a column e.g. 5632 4361 3343...
  10. M

    Ability To Navigate Back To Previous Cell Selected

    I have seen many posts about this but have not really found anything that works for me. I am looking for a hotkey or macro that allows you to go back to the previous cell selected. I am currently using 2003, and I have tried F5 / CTRL+G, someone else mentioned somewhere to try CTRL + Backspace...
  11. M

    Concatenate cells (non-adjacent) asking for separator

    I would like to be able to select different cells, like A4, B2, C1, E5 and have them concatenated in 1 cells whereby I am asked for separator to be used, like space, or comma, or semi-colon separated So, instead of manually adding " " each time in =CONCATENATE(A4, " ", B2, " ", C1, " ", E1)...

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