Maybe you can consider using Advanced Filters since you wanted only certain columns in the output. Refer :
Hi lea You can refer this article : Sunny
Hi Mitul The word EXCEL 365 is text and not number even though part of it is a number. That is why no error message appears. For the error messa...
Hi lea I am using Excel 2010 and I believe the maximum level for nested IF() is 7 (Excel 2010). Maybe you could try breaking your formula into 2...
Hi Paul Thanks for your feedback. Happy to know it is working for you . Cheers Sunny
Hi Giannis Welcome to the forum. Please attach a sample file and describe what you want to do. It will allow us to have a clearer picture. ...
Hi Mitul CASE-SENSITIVE LOOKUP If you look at your ARRAY formula in cell B10 =INDEX(NUMBER,MATCH(TRUE,EXACT(Value,NAME),0)) what is Value referr...
Hi Marcel Welcome to the forum. To find any color I suggest you : 1) Paste the required image into Paint (you can print the screen). 2) Us...
Hi Blanka Thanks for your generous feedback Glad to know it is working for you. Cheers Sunny
Hi Moiz Welcome to the forum. In cell C3 enter =IF(A3<DATE(2016,9,17),ROUND(B3*12.5%,0),ROUND(B3*13.5%,0)) or =ROUND(IF(A3<DATE(2016,9,...
Hi Blanka Not tested on a 64 bit Excel but should work. I have limited the number of GUID generation to 500,000 (Excel maximum rows is around 1 mil...
Hi Jason Welcome to the Forum. I would suggest you use the WEEKNUM() to identify the week number of the dates in both your KPI and Data sheets. ...
The A2 formula is used to compare against the range in the same row to check if it is the minimum value. If it is the minimum then format that cell...
Hi Paul I think you cannot format a formula in a textbox. This is what I came up with. Not elegant (never done this before) but should work. ...
Hi Paul What type of textbox did you insert onto your worksheet? Form Controls, ActiveX Controls or from the Insert-Textbox?