-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
names collection
-
J
Finding the average number of times a name appears in a list of names, for each name
Greetings! Need a little help and any is appreciated. I have a workbook that basically contains a list of names, places traveled, and dates traveled from last year. So this means that there are duplicate names within the names column. My supervisor would like to take that names column...- jkastner
- Thread
- Replies: 1
- Forum: Excel Questions
-
B
More than 1 name for a range
I use named ranges a lot both to identify particular ranges on a sheet, and as markers to identify certain properties of a sheet so that when an auto command happens, it can tailor what it does for the sheet. I have got to the stage whereby I cannot rely on a range - or individual cell - not...- bertiebj
- Thread
- Replies: 6
- Forum: Excel Questions
-
Loading one workbooks Names(i) into another
Hey Excel people, I've got a worksheet that end users fill out. Several of these files will be in one folder. I've got a separate report workbook that will select the folder with a dialog and load every file's data (marked with Named cells) into rows on my DataFarm sheet in the report...- paipimenta
- Thread
- Replies: 0
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
change colour of picture based on cell value
- Replies: 46
hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am... -
VBA - Combine Multiple workbooks into 1 worksheet
- Replies: 45
Hi, I am trying to write a VBA script which will combine multiple workbooks into 1 worksheet, copy and pasting all columns as values. Each sheet... -
Last Display on userform to a Listbox
- Replies: 35
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am... -
Vlookup and hlookup combination
- Replies: 28
Hello forum friends, I am using Excel 2016, XLOOKUP is not an option for me (I think). I have a worksheet that is linked to a website where the... -
Code giving run-time error when called, but not when placed on worksheet.
- Replies: 23
The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when... -
Help with Current and highest streaks
- Replies: 23
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...