Possibly you can also slightly modify your formula to include the VALUE() function eg =LOOKUP(2,1/(Sheet1!$G$2:$G$5<=VALUE(Sheet1!A2))/(Sheet1!$...
Hi Waqas Try using wildcard when matching but make sure that the entire column to search is text and not a mixture of numbers and text. Somethin...
Hi Lisa You will need to create 3 helper columns G, Y and R. In the helper columns you can check the Color column to see if it is G,Y or R and i...
The only way I could think of filtering without affecting the entire row is using a Pivot Table. As Velouria mentioned above, use the Advanced Filt...
Hi Marcy Try =IF(B1="A",EDATE(B2,36),"What you want to show if not A") where 36 represents 3 years (12 months x 3 years) Hope this helps. ...
Hi Maria Can you attach your file so that we can have a better understanding of your issue.
Possibly you can use COUNTA() instead of COUNT() COUNTA() can handle text, numbers etc.
Hi Ellen You can give this a try =IF(LEFT(A1,4)="STOP",MID(A1,FIND("@",A1)+1,11),A1) or maybe =IF(LEFT(A1,4)="STOP",SUBSTITUTE(SUBSTITUTE(...
Hi David The Data Text To Column method works for me (Excel 2010) When selecting the date option make sure you selected MDY (actual format as pe...
Hi Pete Should I have so many criteria, I would consider using VLOOKUP() instead of multiple IFS. Sunny
Hi Salim To add to Phil's reply, you can also use SUBSTITUTE(numtowords(A2) & " only","dollars","euro"), for example. It will replace the do...
Hi Frans I prefer option 1 to set the option to "None" as suggested by Philip. I normally set this option for every PT that I created to prevent...
Try changing the code to: 'Update Data 'find match data Dim index As Integer Dim lastRow As Integer Dim sh2 As Worksheet Set sh2 = ThisWorkbook....
Another suggestion is to use a Pivot Table and group by Months/Years
Hi David You can try hiding the range name with this code: ThisWorkbook.Names("YourRangeName").Visible = False Cheers Sunny