excel best site Archives

Mar32023 by excelhelp13No Comments

Create Dynamic Dropdown list with Indirect formula

A Dynamic dropdown list or dependent dropdown list is very useful while working in Excel. Which makes our work easier and time get saved. Here we have an example of how to create a dynamic dropdown list or dependent dropdown. Example- We have names of some states and their cities. While working in Excel, you should create a dropdown list so that you do not have to type the name of the state or it's city repeatedly. If we select the state name in dropdown the list of cities of that state will appear automatically. We have the following data. In which dropdown list is to be created in column F3 to G6. Steps- To create a dropdown list of state names Select F3 to F6 In the Data tab, Click on Data Validation. In the dialog box that opens, select “L...

Jun92022 by excelhelp13No Comments

Data transpose Dynamically in Excel

tips & Tricks

Transpose function is use to exchange the data from Row to Column and Column to Row. To make your data get update automatically by using transpose function please follow the below mentioned steps. STEPS : Select destination range. (Where you want to transpose data)Type formula =transpose(source data range)Press Ctrl + shift + enter 4. See the result in below image. Data transposed within the selected range. 5. When we edit the source data, the transposed data will changed automatically. See the image below.

Jun22022 by excelhelp13No Comments

Move or Copy Sheet in Excel

Home Menu, Menu Bar

When you need to create a new spreadsheet based on an existing one or move a sheet from one excel file to another, you can move or copy a worksheet in the same workbook or another workbook. 1. Move or Copy a worksheet in the same workbook Open the worksheet you want to move or copy.Home > format > move or copy sheet… (you can also open this option using right click on sheet Tab) The Move or Copy dialog box will then open.Choose where you want to place the copy.Click on Create a copy box. (If you don't Click the create a copy box, Excel will only move the sheet.)Click OK. 2. Move or Copy a worksheet to another workbook Open the worksheet you want to move or copy.Home > format > move or copy sheet… (you can also open this opt...

Apr132020 by excelhelp13No Comments

FIND SMALLEST Number With Position In Excel

Statistical

First Select The Cell Where You Want The Result.Then Apply The Formula And Select The Array / Range And Define The Position. Once Applied It Will Check In The Array And Give You The Result By Finding The Position Of The Smallest Number.That's It :)