formula #explaination

Hi all, I currently have the following setup: The macro will send out an email to the 1st contact and BCC with this VBA code: Option Explicit Private Const FilePath As String = "\\COMPANY.MSAD.COMPANY.NET\userdata\t865934\home\Documents\TESTfolder\" Sub send_email_complete() Dim OutApp As...

# HOW TO MATCH "HSN CODE" AFTER PULL DATA ON DIFFERENT-DIFFERENT TABLES ??? We need pull data into different- different Table . Kindly Help on solve my Query, Kindly Send us Proper formula , - perfect match " HSN CODE" And pull data from TABLE1 , send to matching table

# Get data After match "Code" Both table, Need Result Table2 we need result in table1= 2.50% (Both Table Name Already in red font) How it Possible ??????

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

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 get Sum value via "HSN Code" vise ?????? Advance Condition : "if 100 or More Entries in sheets how it possible to solve query via Formula this Concepts " (without pivotable / without filter/ without VBA)

I'm looking for a formula to show specific text on an overview tab to track colleague "fails" when preforming audits. I am working with multiple sheets. for example say i have an overview sheet, then sheets 1,2, and 3. Sheet2 Cell 'K9' would have the colleagues ID number and cell 'L9' will say...

Hi all, new to the forums so not sure if this is the type of question we can ask here, but I have a workbook with data and tasks to complete on it and I'm having trouble understanding the attached question. Especially when according to my formula (=L2*100/K2) for the ppm none are even 5p?

* how to Apply Condition Formating in Particular Cells At a time, (Condition : IF then " Available Qty " <1 to Highlight Cell is RED color). * This condition Apply but Not properly Working , Pleased help to solve this query, I try to use Multiple criteria using this condition formatting.

Hello, I need help formulating. I'm working on an employee attendance sheet. I need to formulate the total hours/minutes missed. If they were Absent it would equal 8 hours; if they Arrived Late the total amount of hours/minutes they missed; if they Left Early the total amount of hours/minutes...

Ok so I have my monthly bills on one sheet and my overall debt on the second sheet and I want some way to tell excel when I pay a monthly bill and it automatically take that amount off the total debt on the second page. I cannot figure out a way to tell excel when I make a payment. So in my...

hi all, I was wondering if you could advise or point me in the right direction as I want to use the below formula. However, if the word "False" appears it does not show it in the cell? =TEXTJOIN(",",TRUE,UNIQUE(IF(K2:K36=BR2,N2:N36,"")))

This is a non-VBA question. The pic above is referred. Suppose I have this numbers (840312107345; in B3) ; wanted to "extract" ONLY 840312 and re-arrange it to be into a date string as 12-03-84 (D3). Then I'd like to calculate it in field AgeNow(E3) so that it will subtract NOW() & D3 How do...

Hi all, I use a spreadsheet as a tracking doc to keep track of our process from project upload through client approval. The way the doc is set up is Column A (Name) has the name of task. Column B (OMIT) is where we log if a task has been omitted. Column D (Code) host the code I need help...

Hi. I am running into an issue where I need to compare 2 worksheets for inventory changes and product differences. Every formula I have tried has erred on me and I am hoping someone can help as I have been at this for several months. I am visually blind so comparing over 10k lines manually on...

I need to figure out what formula can be used to calculate the difference between the budget vs actual. What I want to happen is, when I put in the "Actual" number value, it will then in the 3rd column (+ / -) populate as either with a red negative value or a green positive value. For example...

Hello All, I am working on a project that has several macros but there is one piece of the puzzle I am unable to completed. I will do my best to explain what I need visually. I have a loop that looks at a sheet (Timing Assumptions) and based on a row called Percentages, the user is able to...

Hello. I need some help with a formula please - i am not even sure if it is possible? I need a formula that will add up the same DD/MM/YYYY in a column and return the sum of matching dates; e.g 13/02/2020 16/01/2020 13/02/2020 13/02/2020 12/01/2020 11/01/2020 I want to...