#query

Hello all, I'm trying to assign all of the expenses that have "Public" in the expense description as operations management in nother field and all other expense that don't have "Public" as "Some other Department". When I run the if statement below as part of my Select query it returns all of...

How to Match workbook to other workbook data & Get status (HOW To MATCH "BOOK2" WITH "BOOK1" , All data Match , to Get Status and Highlight 4 CELL matching How it possible ???

Query : " HOW TO COMBINE " ITEMLIST " & USE IN DROPDOWN LIST (Condition : Inclued Both table "Item list" * Both Table "Item list is different * BOTH TABLE ITEM LIST SHOW ON MY DROP-DOWN LIST . HOW IT POSSIBLE THIS ????? KINDLY SUGGEST RIGHT WAY TO SOLVE THIS QUERY. Note: I was make...

(NEED THIS CONDITION) C2= "20 ft" use 5,00,000 C2= "40 ft" use 10,00,000 Change value According "20 ft" Or "40 ft " ------------------------------Kindly Suggest Right Formula-----------------

:confused:I have a worksheet that searches for staff name, thenpopulates their information from a reference sheet. Then there are trainingclasses listed, and the second formula searches for their name in a trainingrecords table, and if their name and that class title is found, it populates...

Hello fellow Ex(perts), Recently, I have created a table that imports dynamic cryptocurrency data from this website: https://www.bithumb.com/ Since the data I wanted (real-time prices) are constantly updating, I use the "Refresh" tab to keep my data up-to-date. However, I was only able to...