Hello, In a pivot table (having collapsed rows), for a particular column (showing percentage values) I have applied traffic lights which are available in conditional formatting. Here slicers are also created by selecting pivot cells/data. Now when we are selecting an/any option from slicers, the traffic lights are showing incorrect colors for respective percentage values. We have tried multiple ways to fix it but yet they all fail. Please help if somebody knows on the same. Thanks, Hitesh.

I came across this video reading MacKay: Contact Duration and the Costs of Market Transactions, you might enjoy the understanding I gained (obvious to some I suppose), like the lower the variance in supplier costs, the greater the number of suppliers, duration of contract's impact on supplier cost, etc., were factors that may be useful in assisting clients, etc.

This is a crazy way of adding ordinal suffixes. You don’t do this by conditional formatting. You do it by concatenations of the suffixes as strings.

the code works, but it actually deletes all rows, despite the fact that there are other values in the column, like 1, 2, etc. What should I do?

Lovely 💞

Can you please post the codes? tnx

Aw ThAnk u So much i had stubborn ones the Name manager trick i didnt know!

Awesome content. Very clear explanations 👍

Thank you!!!

Hello, would this work on a shared file, i.e., uploaded in SharePoint? Thanks!!!

Clever trick there! ❤️

Sir edit link does not work (disable) Please solve my problem 😥😥

Hello sir, I have a question in excel. Any four number in four different cell that is 10,20,30&40 I want result will be the average of middle of the number it means ignore higher value and lower value. In this example upper value is 40 and lower value is 10 my expected result will 25. Please help and suggest the foramula of this steps

Thank you, how do I exclude header selection?

Does this work for cell referencing in accounts when working with multiple excel sheets?

The question is what if i want to copy the new cells,excel doesnt understand that there is a number there but instead copies the function

Please teach me how to Remove #N/A rows across 100 sheets. All sheets are varied in rows Count (With #N/A)

Thank you so much. this is exactly what I needed. Explained simply and straightforward. Going to "subscribe" your channel. Thanks again.

Still don`t work for me ignoring blanc cells. What can I do here to ignore a blanc cell? : =AVERAGE(30/H42;E42;30/S42;30/T42)

the one with index looks like cheating! lol.. thanks a bunch!

Great. It is very helpful.

Great Job

thanks guys i was looking for something similar for a long time . Appreciate

I have a list of customer ticket # that needs to be QA, using a dynamic number i pull in ticket # and other information from another sheet. I am looking how can i only select number of rows as mentioned in the dynamic number. The code in the video returns blank cells at the bottom of the list which has formula in it Cell B9 Number of ticket to review Cell B10 40 Cell B11 Cell B12 ticket 1 Cell B52 ticket 40 so it should only select Cells B9 to M52, Column B to M also has data pulled from other sheet)

Thank you very much

Your Link is not available anymore for Drop Down Horizontal Range. Can you please have it available to see. Thank you

Great videos

Clearly and easy tips to apply. Thks

What is the criteria range for (column B in your case)? Why do we need it? What does it do?

Hey there ! can this code update existing values in the sheet ? I'm presenting my case here if you could help me with this please I need to update new values (unique) from source sheet to destination below the last row and also update the existing records . I've 2 operators to get this for any new records created there's date col in source sheet to identify that and update date col has the values updating the records . So have no prior experience in VBA so really confusing in handling logical operators to get my desired result. If you could assist me please !

Hi, I have the following problem: I'm running MS Office Professional Plus 2019 and have created a folder on my desktop. Inside this folder, I have created two seperate MS Excel workbooks - one containing text while the other contains screenshots or images that correspond to some of text in the other workbook. In the workbook containing text, I have created links to images that I have put in the other workbook. The idea is to read text and see corresponding images with a click of a button. Now the problem start to arise whenever I 1). add additional columns in the workbook that contain images or 2). re-locate the folder containing these two workbooks. I wonder if there is any way around this problem?

THX so mutch

Great... Very Useful Calculation. Thank you

i hate school

Very helpful! solve my problem in 5 sec! Thank you!

This video was exactly what I needed. You're a legend!

Very clever. I love it. 👍👍👍👍

Thank you! I had a column with dollar signs that exported as text so I had to remove the $. I swapped the word "left" with "right" and it worked great!

what we will do when we are adding a sheet after the implementation of the formula??

'Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'On Error Resume Next 'Application.ScreenUpdating = True 'With Sheet1 'Rows(lastrow).AutoFill Rows(lastrow).Resize(2), xlFillDefault Range("A1:A3").AutoFill Destination:=Range("A1:A60") ' Range("M10").Formula = "=IF(OR(ISBLANK(D6),ISBLANK(E6),ISBLANK(F6),ISBLANK(C6)),(FG65+D6-E6-F6))" Range("A1:A3").AutoFill Destination:=Range Balance("A61") ("A1+A60) 'Application.ScreenUpdating = False 'End If 'End With 'End Sub can pls help me correct

Fast and quick. Thank you!

Name manager approach saved my life, thank so much!!!

You are good!! But what if we want to delete only specific rows (eg B and C) if in case the column in I is blank? Please suggest

Thanks

Hello, thanks for so very helpful tutorial. I have an issue in the macro in the line referring to the goal seek. When I try to execute the program an error message pops out saying the reference is not valid, and it highlights the line of the goal seek script. Any help please?

What the hell is wrong with people putting bloody music in these videos. Tell me why you need music,please.Its distracting.

Is it possible to auto-create new links in the table of contents for recently added worksheets?

You are too fast and You don't go straight to the point "breaking external links in excel"...

nice. but please given the file, sir.

Hi ad, I have a problem with the code macro: can't execute code in break mode . the mistake at : lookFor = findArray(i, 1) If inArray(j, 1) = lookFor Then outArray(i, 1) = inArray(j, 2) Exit For End If Next j Next i can you please give me a hand? thank so much for helping.