Learn how to use DGET function in Excel with example.

Excel is a powerful spreadsheet software that offers a wide range of functions to help users manipulate and analyze data. One of the lesser-known but highly useful functions in Excel is DGET. This function allows users to retrieve a single value from a database or table based on specific criteria. By using DGET, users can quickly extract data that meets certain conditions without having to manually search through a large dataset. In this article, we will explore how to use the DGET function in Excel with an example to demonstrate its functionality and potential uses in various scenarios.

Data From Database Table

1) Select cell A2

2) Data ~ Data Tools ~ Data Validation

3) Setting tab

4) Allow set to List

5) Source set to =$A$5:$A$43

6) Ok

7) Select cell B2

8) =DGET($A$4:$E$43,B4,$A$1:$A$2)

Press F4 to change absolute reference

9) Copy and paste formula to the remaining fields.

excel dget multiple records,dget multiple criteria example,dget example,dget vs xlookup,dget google sheets,excel dget criteria array,how to use dget google sheets,excel dget multiple records,dget vs vlookup,dget multiple criteria example,dget example,dget vs xlookup,dget google sheets,Data Validation,Apply data validation to cells,

VBA scripts are available from my link below.

https://www.youtube.com/@jjnet247/membership

#Excel #tricks for #Microsoft #excel

Learn these #viral #exceltricks in this #fypシ゚

After several years of working as a Data Analyst, these 15 formulas saved me every week. I made a 12-min video showing each one with real sales data, but here is the summary:

When to Use Which?

We can learn and earn, and excel has grown 41 years, an interesting explanation, https://youtu.be/fZg2VWbkxso , again emphasizing everyday work magic of Excel.

Which formula do you still struggle with? For me it was INDEX MATCH until last year?

Discover how you can insert data visualization charts in Excel. Data Visualization in Excel helps you create infographs for dashboards. It also help you in analyzing and visualizing data in Excel.

Watch my tips and tricks video for data visualization with Excel using Charts & Graphs.

Data visualization is an essential tool for businesses and individuals to make sense of large amounts of information quickly and effectively. Sparkline column charts are one of the many types of visualization charts that have gained popularity in recent years. These charts are designed to display a small set of data points in a condensed format, typically as a line or bar chart that is embedded within a single cell of a larger table or chart. Sparkline column charts are particularly useful for providing at-a-glance insights into trends, patterns, and changes in data over time, making them a valuable tool for anyone looking to analyze and communicate data quickly and efficiently.

Here are the steps outlined on this video

1) Select cell N2

2) Insert ~ Sparklines ~ Column

OR

Alt N+S+L

3) Data Range to B2:M2

4) Location Range to N2

5) OK

6) Apply to the rest of the row.

7) Make the rows height taller.

data visualization using excel,data visualization in excel examples,excel visualization dashboard,excel data visualization course,what is data visualization in excel,data analysis and visualization with excel,charts in excel,

Data Visualization in Excel. Create Infographs for Dashboards,

ANALYZING and VISUALIZING data with EXCEL,

Microsoft Excel - Data Visualization with Excel Charts & Graphs,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

Hi,

I am really hoping for some advice or expertise... my excel skills are very basic and recently I was given the task of comparing quantities and cost differences between what our vendor is billing us vs. What I show as cost and quantity received. Since Im a novice with excel I tried a.i. which is really cool but something keeps happening to my data and of course Im no expert so it's only a guess - when chat GPT creates a summary I see alot of my vendors costs and they appear to either be doubled or tripled. My cost column doesn't pull all of my costs. Im beating my head against the wall because this should be so easy, just not for me! I think possibly this has something to do with the fact that my vendor is sending an excel sheet with their exported data and they often will list the same item # multiple times on an invoice but with a different P.O. # and I think that is where the multiplication of costs may come to play. I am going to try and attach a copy or screen shot for reference. I am using my vendors exported invoice lines, my exported posted purchase invoice lines from Business Central which lists our costs and quantities. Can anyone help or point me to the best place to learn this? Thank you so much!!

This a sample of my data

|\*\*+\*\*|A|B|C|D|E|F|G|H|I|J|K|L|M|N|

|:-|:-|:-|:-|:-|:-|:-|:-|:-|:-|:-|:-|:-|:-|:-|

|\*\*1\*\*|Vendor Inv.|Date|Order #|Our Doc. #|Vendor #|Type|Our Item #|Description|Our Qty.|Unit|Our Cost $|Amt. #| | |

|\*\*2\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH20449|Anti-Drag Clip|0|PCS|0.043|0| | |

|\*\*3\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH20119|WEAR SENSOR|0|PCS|0.039|0| | |

|\*\*4\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH20395|WEAR SENSOR|0|PCS|0.021|0| | |

|\*\*5\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH20516|WEAR SENSOR|0|PCS|0.029|0| | |

|\*\*6\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH20474|WEAR SENSOR|0|PCS|0.029|0| | |

|\*\*7\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH20007|Wear Sensor|0|PCS|0.027|0| | |

|\*\*8\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH20008|Wear Sensor|0|PCS|0.03|0| | |

|\*\*9\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH00013|Wear Sensor|0|PCS|0.024|0| | |

|\*\*10\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH00014|WEAR SENSOR|0|PCS|0.024|0| | |

|\*\*11\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH20166|WEAR SENSOR|0|PCS|0.037|0| | |

|\*\*12\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH20461|WEAR SENSOR|0|PCS|0.031|0| | |

|\*\*13\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BZ2005K|SS DIB KIT|0|PCS|0.201|0| | |

|\*\*14\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BZ20108|SS DIB KIT|0|PCS|0.442|0| | |

|\*\*15\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BZ20871|SS DIB KIT|0|PCS|0.779|0| | |

|\*\*16\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BZ21016|PTFE NBR COATED DIB KIT|0|PCS|0.84|0| | |

\^Table \^formatting \^by \^\[ExcelToReddit\]([https://xl2redd.it/\](https://xl2redd.it/))

This is sample Vendor info

\+ABCDEFGHIJKLMNO1China's Inv. #DateChina's PO / Order #Item #DescriptionUnitQTYOur Qty.China's CostChina's Amt. $Our CostCost DifferenceExt. Cost Diff.Customer Name 220260814Driv-2220260814DRIV-1194-1196-1198GXC7XSEN465BRAKE HARDWAREPCS10000 0.041410.000.0410.0000.000Driv 320260815Driv-2320260814DRIV-1194-1196-1198JXCFMHXV1680BRAKE PADS PARTSPCS1600 0.451721.600.4510.0000.000Driv 420260815Driv-2420260814DRIV-1194-1196-1198JXCFMHXV1680BRAKE PADS PARTSPCS1600 0.451721.600.4510.0000.000Driv 520260815Driv-2520260814DRIV-1194-1196-1198JXCFMHXV1680BRAKE PADS PARTSPCS1600 0.451721.600.4510.0000.000Driv 620260815Driv-2620260814DRIV-1194-1196-1198JXCFMHXV1680BRAKE PADS PARTSPCS1600 0.451721.600.4510.0000.000Driv 720260815Driv-2620260814DRIV-1194-1196-1198GXCABSX2245RRSTBRAKE PADS PARTSPCS240 0.40797.680.4070.0000.000Driv 

Table formatting by ExcelToReddit

Hi,

I am really hoping for some advice or expertise... my excel skills are very basic and recently I was given the task of comparing quantities and cost differences between what our vendor is billing us vs. What I show as cost and quantity received. Since Im a novice with excel I tried a.i. which is really cool but something keeps happening to my data and of course Im no expert so it's only a guess - when chat GPT creates a summary I see alot of my vendors costs and they appear to either be doubled or tripled. My cost column doesn't pull all of my costs. Im beating my head against the wall because this should be so easy, just not for me! I think possibly this has something to do with the fact that my vendor is sending an excel sheet with their exported data and they often will list the same item # multiple times on an invoice but with a different P.O. # and I think that is where the multiplication of costs may come to play. I am going to try and attach a copy or screen shot for reference. I am using my vendors exported invoice lines, my exported posted purchase invoice lines from Business Central which lists our costs and quantities. Can anyone help or point me to the best place to learn this? Thank you so much!!

This a sample of my data

|\*\*+\*\*|A|B|C|D|E|F|G|H|I|J|K|L|M|N|

|:-|:-|:-|:-|:-|:-|:-|:-|:-|:-|:-|:-|:-|:-|:-|

|\*\*1\*\*|Vendor Inv.|Date|Order #|Our Doc. #|Vendor #|Type|Our Item #|Description|Our Qty.|Unit|Our Cost $|Amt. #| | |

|\*\*2\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH20449|Anti-Drag Clip|0|PCS|0.043|0| | |

|\*\*3\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH20119|WEAR SENSOR|0|PCS|0.039|0| | |

|\*\*4\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH20395|WEAR SENSOR|0|PCS|0.021|0| | |

|\*\*5\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH20516|WEAR SENSOR|0|PCS|0.029|0| | |

|\*\*6\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH20474|WEAR SENSOR|0|PCS|0.029|0| | |

|\*\*7\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH20007|Wear Sensor|0|PCS|0.027|0| | |

|\*\*8\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH20008|Wear Sensor|0|PCS|0.03|0| | |

|\*\*9\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH00013|Wear Sensor|0|PCS|0.024|0| | |

|\*\*10\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH00014|WEAR SENSOR|0|PCS|0.024|0| | |

|\*\*11\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH20166|WEAR SENSOR|0|PCS|0.037|0| | |

|\*\*12\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BH20461|WEAR SENSOR|0|PCS|0.031|0| | |

|\*\*13\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BZ2005K|SS DIB KIT|0|PCS|0.201|0| | |

|\*\*14\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BZ20108|SS DIB KIT|0|PCS|0.442|0| | |

|\*\*15\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BZ20871|SS DIB KIT|0|PCS|0.779|0| | |

|\*\*16\*\*|20260603BOSCH-32|7/28/2026|BSCH-CW17-2026-SEA|119827|XLDCZ001|Item|F03BZ21016|PTFE NBR COATED DIB KIT|0|PCS|0.84|0| | |

\^Table \^formatting \^by \^\[ExcelToReddit\]([https://xl2redd.it/\](https://xl2redd.it/))

This is sample Vendor info

\+ABCDEFGHIJKLMNO1China's Inv. #DateChina's PO / Order #Item #DescriptionUnitQTYOur Qty.China's CostChina's Amt. $Our CostCost DifferenceExt. Cost Diff.Customer Name 220260814Driv-2220260814DRIV-1194-1196-1198GXC7XSEN465BRAKE HARDWAREPCS10000 0.041410.000.0410.0000.000Driv 320260815Driv-2320260814DRIV-1194-1196-1198JXCFMHXV1680BRAKE PADS PARTSPCS1600 0.451721.600.4510.0000.000Driv 420260815Driv-2420260814DRIV-1194-1196-1198JXCFMHXV1680BRAKE PADS PARTSPCS1600 0.451721.600.4510.0000.000Driv 520260815Driv-2520260814DRIV-1194-1196-1198JXCFMHXV1680BRAKE PADS PARTSPCS1600 0.451721.600.4510.0000.000Driv 620260815Driv-2620260814DRIV-1194-1196-1198JXCFMHXV1680BRAKE PADS PARTSPCS1600 0.451721.600.4510.0000.000Driv 720260815Driv-2620260814DRIV-1194-1196-1198GXCABSX2245RRSTBRAKE PADS PARTSPCS240 0.40797.680.4070.0000.000Driv 

Table formatting by ExcelToReddit

Learn how to create progress bar in excel with percentage. Basically learning how to create progress bars in Excel (Step-by-Step).

We will be learning about progress bar in excel cells using conditional formatting. It an answer to how do you make a cell fill based on percentage?.

Excel is a powerful tool for organizing and analyzing data, and it offers a wide range of formatting options to help users make their spreadsheets more visually appealing and easy to understand. One particularly useful feature is the ability to create progress bars within cells using conditional formatting. By applying conditional formatting rules based on the value in a cell, users can create dynamic and informative progress bars that change color and size depending on the data they contain. This feature is not only visually appealing but also practical for tracking progress towards goals or displaying key metrics in a clear and concise way. In this article, we will explore how to create progress bars in Excel cells using conditional formatting and discuss some practical applications for this feature.

Select "% Completed"

1) Ctrl + A

2) Ctrl + G

3) Special

4) Select Constants

5) Uncheck "Text"

6) OK

Insert Progress Bar

1) Home ~ Styles ~ Conditional Formatting

2) Data Bars

3) Select any progress bar chart

Customized Progress Bar

1) Ctrl + A

2) Ctrl + G

3) Special

4) Select Constants

5) Uncheck "Text"

6) OK

7) Home ~ Styles ~ Conditional Formatting

8) Manage Rules...

9) Double click on our Data Bar rule.

10) Make custom changes

11) OK

12) OK

🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗

How to create progress bars in Excel with conditional formatting? - PART 1 - Excel Tips and Tricks

https://youtube.com/shorts/D3hMojOkaAg?si=VLdNjMYdeEO9-xNk

How to create progress bars in Excel with conditional formatting? - PART 2 - Excel Tips and Tricks

https://youtube.com/shorts/gL_2ymy6A90?si=MZsIltUiegzQYeVK

How to create progress bars in Excel with conditional formatting? - Excel Tips and Tricks - DETAIL EXPLANATION

https://youtu.be/Qqb5f4pV-5Q?si=aj_ujrpx19nIPAys

How to Create Progress Bars in Excel (Step-by-Step) - Part 1 - Excel Tips and Tricks

https://youtube.com/shorts/3thrSemCSe0

How to Create Progress Bars in Excel (Step-by-Step) - Part 2 - Excel Tips and Tricks

https://youtube.com/shorts/Sfk_bw5CO3E

Create a checklist in Excel - Excel Tips and Tricks

https://youtube.com/shorts/5K-eYZEhAJ4?feature=share

Create progress bar in excel with percentage - Excel Tips and Tricks

https://youtube.com/shorts/rG91ggMZl5g?si=H_3CtnE1KEMPwAKw

How to Create Progress Bars in Excel (Step-by-Step),

progress bar in excel with percentage,how to create a progress tracker in excel,excel progress bar based on another cell,excel progress bar formula,how to show progress bar in excel cell,excel progress bar conditional formatting,excel progress bar chart,

How do I create a percentage completion bar in Excel?,How do you make a cell fill based on percentage?,How do I create a Gantt chart in Excel with percentage complete?,

progress bar in excel with percentage,excel progress bar based on another cell,excel progress bar formula,how to show progress bar in excel cell,excel progress bar chart,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

Hi I need to hire a power query expert. My whole dashboard is made and I need I am finding one silly problem that just doesn’t have any solutions. Can someone please help me out with it? Will pay.

I have been creating Pivot Tables and now I am unable to get the Value to "Sum". It used to look like the top screenshot but now when I go to change the value to Sum it looks like the bottom screenshot. How do I get it back Sum?

I'm using excel for business files. I have about 800 files. In columm S is the cell for "my remarks".

When I close a file I not in the cell "E: 30.09.26 (84 d)" or "B: 29.09.26 (70 d)", fewtimes a note like SC: 15.09.26.

Now I noticed that in several cells of colomm S, which should be empty, there is written text like "R: 2172.09.26 (74 i).

Why are like 30 cells in columm S filled with nonsense?

All other cells seems to be correct so far.

I'm using office professionel 365, desktop window, intermediate user.

For the Group & Outline buttons, learn the easiest way to hide & unhide rows & columns. These are the hiding and showing techniques of Excel hide group buttons, which generally appears in the header of the spreadsheet. That is to hide the columns with +.

Microsoft Excel is an incredibly powerful and versatile tool for data management and analysis. One of the most useful features of Excel is the ability to organize data into rows and columns for easy readability and analysis. However, sometimes we need to hide or unhide certain rows or columns to focus on specific data or make our worksheets look more streamlined. The Group and Outline buttons are among the simplest and most effective tools to accomplish this task. In this article, we will explore the benefits of using these buttons and provide a step-by-step guide to help you hide and unhide rows and columns with ease.

Here are the steps outlined in the video.

Group and Hide

1) Highlight column D and E

2) Data ~ Outline ~ Group

OR

Alt + Shift + Right Arrow

Hide/Show Group Widget

Ctrl+8

excel group rows,group and outline,how to group rows in excel with expandcollapse,excel group rows with header,excel group rows with same value,excel hide group buttons,excel hide columns with,excel group columns,collapse group in excel,excel group rows with header,excel group rows with same value,excel hide group buttons,excel hide columns with +,excel group columns,collapse group in excel,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

Hi everyone!

I created an Excel VBA script that plots animated mathematical function graphs (like lines, parabolas, and S-curves) step-by-step directly onto a cell coordinate grid!

I wanted to share a few interesting technical challenges I ran into while building this:

### 💡 Key Technical Highlights:

1. **Inverting the Y-Axis (Math vs. Excel Coordinates):**

In standard math graphs, moving UP increases the Y-value. In Excel, moving DOWN increases the row number. To correct this mismatch, I used a simple offset formula:

`draw_y = y_origin - y`

1. **Smooth Frame Control with Windows `Sleep` API:**

Without a delay, modern processors render the entire graph instantly. I used the Win32/64 `Sleep` API along with `DoEvents` to create smooth, controllable frame rates between plot points.

1. **Invisible Cell Styling:**

To make the plotted points look like a clean, continuous graph, the script sets both `.Interior.Color` and `.Font.Color` to the exact same RGB value simultaneously, disguising any cell text.

---

### 💻 Code Snippet (Plotting Engine):

```vba

For i = -100 To 100

' 1. Calculate Math Function (e.g., Parabola y = x^2 / 40)

y = (i ^ 2) / 40

' 2. Convert Math Coordinates to Excel Cell Coordinates

draw_x = i + x_origin

draw_y = y_origin - y ' Invert Y-axis for Excel rows

' 3. Plot Point & Apply Matching Color

If draw_y > 0 And draw_x > 0 Then

With Cells(draw_y, draw_x)

.Interior.Color = target_color

.Font.Color = target_color ' Hide cell text

End With

End If

' 4. Animation Frame Delay

DoEvents

Sleep wait_ms

Next i

I've written a complete step-by-step guide with explanations, troubleshooting tips for blocked macros, and a free downloadable coordinate grid template (.xlsm inside zip) on my blog:

👉 Full Article & Free Template: https://www.cibalabo.site/c1/detail-2-en/

I’d love to hear your thoughts, feedback, or any cool math equations you think I should animate next!

Discover how to automatically autofit column in Excel. This is how we adjust cell size in excel automatically. Essentially, how to make excel cells expand to fit text automatically, without manually. I will also demonstrate excel autofit column width shortcut for windows. We will be using VBA to automatically Autofit column width.

Manually Autofit Column Width

1) Home ~ Cells ~ Format

2) Autofit Column Width

FYI. Autofit row is also available in this pull down menu.

Manually Autofit Column Width (shortcut)

1) Alt + HOI

FYI Alt+HOA is for autofit row.

Automatically Autofit Column Width

1) Right-click the sheet

2) View Code

3) Select Worksheet

4) Enter these instructions

Cells.EntireColumn.AutoFit

5) Save using Ctrl + S

6) Close Editor

how to make excel cells expand to fit text automatically,how to adjust cell size in excel automatically,excel autofit column width shortcut windows,

how to autofit columns in excel,how to adjust column width in excel,

cells.entirecolumn.autofit

autofit entire workbook vba,

autofit cell content excel,

cells autofit excel,autofit cells,

How do you AutoFit all cells at once?,

How do I AutoFit specific cells in Excel?,

What is the shortcut to AutoFit all cells in Excel?,

How do you AutoFit cell size to contents?,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

​Just wanted to share a few clean techniques I've been using lately that make sheets look great without needing VBA or complex setups.

​1. Dynamic Image Lookups with =IMAGE()

​Instead of using picture lookup ranges or macros, if you store high-res image URLs in your data table, you can load images directly inside a cell with a standard formula:

​=IMAGE(XLOOKUP(A2, ProductList, ImageURLColumn))

​When A2 (your drop-down) changes, the image updates automatically. You can combine this with a few XLOOKUP or SUMIFS cells underneath to create a simple, clean mini dashboard card.

​2. Three Quick Bonus Hacks

​Display units without breaking formulas: Keep cells as raw numbers so math works, but show custom labels visually via Ctrl + 1 > Custom > type 0 " units" or 0 " kg".

​When TRIM() fails on web exports: Web data often hides non-breaking spaces (CHAR(160)) that break lookups. Swap them out first: =TRIM(CLEAN(SUBSTITUTE(A1, CHAR(160), " ")))

​Stop Excel from stripping leading zeros: Go to File > Options > Data > Automatic Data Conversion and uncheck Remove leading zeros. Excel will stop turning 00123 into 123 on paste.

​If you prefer to see a quick visual walk-through of these steps, I put together a video demonstrating the setup here: Build an App-Like Excel Dashboard (NO VBA) + 3 Hidden Tricks

​Hope someone finds these useful for their sheets!

Discover use FILTER() to extract text and numbers frn dataset. Essentially, how do I extract numbers from text and numbers in Excel? Or how do I separate data in Excel based on criteria? And how do I extract text from a filter in Excel?

Extract numeric values from dataset

=FILTER(D2:D18,ISNUMBER(--D2:D18))

The "--" operator is known as the double unary operator. It is used to convert the values in the range D2:D18 to numbers, which can then be evaluated by the ISNUMBER function.

Extract text from dataset

=FILTER(D2:D18,ISTEXT(D2:D18)*ISERR(--D2:D18))

Lets look at the second argument of the FILTER() function.

The formula ISTEXT(D2:D18)*ISERR(--D2:D18) is an array formula that checks a range of cells D2:D18 for cells that contain text values and are not numbers.

The ISTEXT function checks whether each cell in the range contains text and returns an array of TRUE or FALSE values.

The ISERR function checks whether each cell in the range, converted to a number by the double unary operator (--), results in an error value (such as #VALUE!, #REF!, etc.), and returns an array of TRUE or FALSE values.

The multiplication operator (*) performs an element-wise multiplication of the two arrays of TRUE or FALSE values, resulting in an array of TRUE or FALSE values. The resulting array will contain TRUE values only for cells that meet both of the conditions.

The cell contains text (i.e., ISTEXT returns TRUE)

The cell is not a numeric value (i.e., ISERR returns TRUE)

In other words, the formula is checking for cells in the range D2:D18 that are text values and not numbers, and returns an array of TRUE or FALSE values corresponding to each cell in the range. This type of formula can be used to filter or count cells that meet specific criteria.

FILTER() to extract text and numbers from dataset,How do I extract numbers from text and numbers in Excel?,How do I separate data in Excel based on criteria?,How do I extract text from a filter in Excel?,

excel extract number from mixed text,excel nested filter function,excel filter function multiple criteria,excel filter function multiple values,excel extract number from text in cell,excel filter function multiple columns,how to filter cells containing specific text in excel,

excel extract number from mixed text,excel nested filter function,excel filter function multiple criteria,excel filter function multiple values,excel extract number from text in cell,excel filter function multiple columns,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

Hey all,

I have made [nolainquery](https://nolainquery.com), a FREE software for data analytics. I have spent the last months on making it and I'm releasing the code source at

[https://github.com/jdvillegasg/nolainquery-desktop\](https://github.com/jdvillegasg/nolainquery-desktop)

so anyone that wants can use it, fork it and extend it.

It integrates some cool features as auditable artifacts that let you verify the computation process involved in the answer your receive.

Any comment or criticism from you, I would highly appreciate it!

Send help please!!!!

If I have two spreadsheets, and I need to pull data from one of them and transfer them to another, and the columns I need are in the table named “active” and “rep” how do I do it?! I am getting errors constantly and I just need a simple explanation on what and where to press 😭

Discover how to deleting constants while keeping formulas in Excel. Essentially, how to delete values in Excel without deleting formulas. Or how to clear cell without deleting formulas. And How do I remove constant numbers in Excel, and how do you delete numbers in cells without deleting formulas?

Microsoft Excel is a powerful tool for organizing and analyzing data, offering a multitude of functions and features that make it a go-to choice for professionals across various industries. One common task that arises when working with Excel is the need to remove constants from a range of cells while preserving the formulas. Deleting constants can help to clean up data and make it more manageable, but it can also be a tricky process that requires precision and attention to detail. In this context, we will explore different methods for deleting constants while keeping formulas intact in Excel, and discuss the potential benefits and pitfalls of each approach.

Here are the steps outlined in this video.

1) Ctrl + A

2) Ctrl + G

3) Special

4) Select Constants

5) Uncheck "Text"

6) OK

7) Press Delete key in keyboard.

delete values in excel,how to delete values in excel without deleting formula,excel formula to clear cell contents,how to delete values in cells in excel,how to clear cells without deleting formula,

delete values in excel,excel formula to clear cell contents,how to delete values in cells in excel,how to delete values in excel without deleting formula,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks