excel & lookup & search

Hi all, I have this diagram: However, the "above average", "average", "below average" etc. are really filling up a huge portion of the pie chart. Can somebody please assist me in how I can hide them without removing them? Thanks!

Hi. I'm hoping you guys can help me get this answer. I'm sure its fairly simple for you guys. I am trying to gather info on a customer who ordered something last. I have all the data dumped on a "Data" tab and there may be multiple rows of the same item number and the same customer name. It...

Hi there, This is a work question (using 365), so I've tried to recreate mock data on my home laptop. So unfortunately the FILTER function doesn't work on my mac. Heres a mock data set: Date Description 1 Description 2 Description 3 Combined 1+2+3 Amount 10/10/21 MERCH 9812374 10.10...

Dears, As per discussion on Youtube Channel, please find hereinafter the spreadsheet to help in find out a method to handle the DATA redistribution over other sheets. How to distribute DATA in Sheets (INPUT1 + INPUT2) based on Columns J " CODER" over the the other sub sheets {LELA, AMAL, BURAQ...

Hello, first post here :) I have the following problem: -I have extensive lists of sentences in Excel, in which there are words ending and beginning with <strong></strong>. -Every day new words appear having these <strong></strong> remarks. -There is the need of creating a macro to automatize...

Hello guys, I have this case below and my aim is to fill up column H for subtasks. Needed result is that all sub-tasks below story should have the same fix version value than their story. Can you please share with me the right formula to achieve this? Thanks in advance.

I got data in sheet1 and sheet2, which i want to copy and paste in sheet3. That is already done. So next i want to match rows, by checking column C, D, E, H and I. The C and H column value is integer and the rest is text/strings. If two rows match, then i want to copy and paste one of the lines...

I Need Hyphen " - " Symbol via Formula, Unique Number based Condition , Found Duplicate & set Hyphen Symbol - in D Coloumn

Hello, i would like to make a data input from two workbooks that is in the same path. The data input should be in the master workbook from those two files. The first sheet in the master workbook should just be empty as im going to make macro run buttons for later purpose. The data from the first...

Hello everyone I would love some help to develop some VBA code. But im very new to VBA. Hope someone can help me with it, and i know its a lot to implement. So its for private purpose and a "just for fun project". The project is that i want to two files in a path that i want to match with...

I have a excel with a line with multiples numbers in pairs of 18 and a ",(space)" then the next 18 numbers like this "869353363609899039, 869353363609899040, 869353363609899044, 869353363677020214, 869353363769290771, 869353363807010852, 869353363815411754, 869353363815411756...

#Get data "Sheet 1" to "Sheet 2" in excel ( Check in Image , Sheet 1 many Spaces in there , So i Need "invoice Number list" on Sheet 2 (Auto Generated) how to possible get data as a list format, NOTE: SHEET 1 : *** So many Space in there*** SHEET 2...

Autogenerate serial number according cell reference Number ???? I have try cell Reference : A2 =11 i try cell reference A2 to B3 , problem is B3 Cell value According Auto generate serial Number.

Hello All, I created a Excel Workbook to enter and track quotes for something I am working on.. It works good to enter data, calculate additional charges ect and hold the quotes in a seperate sheet. The sheet has a macro to copy from the input sheet to a sheet called database to hold all of...

i need only one Column , how to remove unuse area in classics pivot table ????? Show me how to delete empty column formatting

@ How to show selected menu in slicer to other cell ??? (Like a Reference Indication) in pivot table ???? I have Try selection in slicer information reference to other cell , Above image like this yellow Highlight cell this reference

How to match Same number via join data NOTE: Not use this formula ( =+C3&" "&D3&" / "&C5&" "&D5&" / "&C6&" "&D6) WE NEED THIS PERFECT FORMULA IN THIS QUERY

i was try "Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???" how to possible Conditional Formatting ????

@ How to make One Dropdownlist , Including all table Column Cell Details Show ???? without Dependent Dropdownlist ??? How to show dropdownlist using different -different Columns data , And Add Included Single Dropdownlist ************************************************NOT USE DEPENDENT...