![]() |
#4
|
||||
|
||||
![]()
Alternatively : What you need to do is write the VSTACK formula, let's say in K1. Then, point the DV list to =K1#
( VSTACK returns an array whereas DV needs a reference to a range)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data Validation | firozmohammed | Excel | 4 | 11-18-2023 01:55 AM |
![]() |
BoardingSUP | Excel Programming | 5 | 10-17-2021 08:05 AM |
Need to copy specific ranges column data as row data from one worksheet to another using excel VBA | ganesang | Excel Programming | 1 | 03-26-2020 06:18 AM |
![]() |
Rich18144 | Excel | 4 | 01-14-2016 04:37 AM |
Data validation with IF | Klyxrastafari | Excel | 1 | 10-03-2011 04:41 PM |