Forum

Lionel Baijot
@questvba
Estimable Member
Joined: Sep 9, 2020
Topics: 8 / Replies: 117
Reply
RE: Need help for formula error

Hi Rajan, Here is a suggestion in the attached file. BR, Lionel

3 years ago
Reply
RE: Drop down list with wildcard?

Good job Kenneth ! Sorry for the French vesrion of formulas. BR, Lionel

3 years ago
Reply
RE: Drop down list with wildcard?

Hi Kenneth, Here is a solution without VBA and only with formulas ; Drop down list et Named area. BR, Lionel

3 years ago
Reply
RE: Moving from current worksheet to last active worksheet?

Hi Alan, Here is a VBA solution. 1. In ThisWorkbook, you paste the following two codes. The first code allows you to initialize the shortcut ...

3 years ago
Reply
RE: Lookup error

Hi Nathaniel Sawyerr, I have an error trying to download your file. Could you reload it? BR, Lionel

3 years ago
Reply
RE: Auto distribute quantities to meet a budget number

Hi, Anything is possible with Excel. But we have too little information to give an answer. Can you order just one of these items? Can you order...

3 years ago
Reply
RE: How to select column # and row # based on the nearest #?

Hi Dave, Sorry for the misunderstanding, I didn't catch the exact request. Mynda gives you a very good solution. And I have another one. BR, ...

3 years ago
Reply
RE: How to select column # and row # based on the nearest #?

Hi Dave, This is the formatting solution for row and column headers. BR, Lionel

3 years ago
Reply
Reply
RE: if function with dependant

Hi, Here is a solution in your file. BR, Lionel

3 years ago
Reply
RE: How to remove excessive formatting?

Hello Trevor You can use CTRL+End to see which cell is the last active cell in each tab. If you delete unnecessary rows and/or columns, don't forge...

4 years ago
Reply
RE: Two dependent lists without duplicates

Hi Mynda, This is my problem. I am part of a company that has a strategy of... blocking updates. So I find myself with an Excel that is getting old...

4 years ago
Reply
RE: Two dependent lists without duplicates

Indeed, these functions are not available.

4 years ago
Reply
RE: Two dependent lists without duplicates

Hi Velouria, My version : Microsoft Excel 2016 MSO (16.0.8201.2193) 32 bits. + Subscription: Microsoft Office 365 ProPlus

4 years ago
Page 3 / 9