Search results

Hi: You may have to rearrange your data in a certain way and draw a pivot to get what you are looking for, again without knowing the full scope of your work it is hard to give a customised solution. Thanks

Hi: I am not going to create a sample file for you and write code, you will have to upload a sample file if you need help. Thanks

Hi: May be this? Thanks

Hi: This is relatively easy to do, upload a sample file. Thanks

Hi: Wrap the formula in a if condition like If(istext(formula), "Include","Exclude") Thanks

Hi: May be this? Thanks

Hi: May be this? =SUMPRODUCT(--(LEN(AZ8:AZ488)>0)) Thanks

Hi: Without seeing your data it is difficult to give you a precise solution. Do you want to find the highs and lows of deposit alone or on the net value(deposit-withdrawal)? Meanwhile try using the native function "Large" for the most amount and "Small" for least amount. Thanks

Hi: If you have cells to be counted is always coloured you can use GET.Cell function to identify the colour and use count if. Thanks

Hi: Why can't you pull a pivot to summarise the data. Thanks

Hi: You can use data validation to you achieve this Step1: Give a formula in a cell= Today()-4 Step 2: Use the following setting in data validation(here I have given the formula in Cell A1) Step 3: Apply this validation to whichever cell you this rule to apply. Thanks

Hi: This is a frequently asked question in this forum, do a search in here you will get what you are looking for.... Thanks

Hi: Don't worry about change type that is a default step that power query creates I have not done that step manually. I have not done anything fancy, I just added an additional step to filter for ABC from your raw table, the coloured portion in your raw table is where you will manually enter...

Hi: I have made the file much simpler. Thanks

Hi: I do not think what you are trying to do is logical because there is no link established between the table in Financial tab and ABC Cost Centre tab. Even though both the tables are same, Excel fails to identify the rows and establish a relationship when you enter forecasting values...

Hi: Find the attached. I have used volatile function Indirect to achieve this, won't recommend it unless you have no other choice, but will give you what you are looking for. I have done it for 3 sample floors. Note: I am assuming the data structure will be same across all the tabs. Thanks

Hi: How many tabs of data you have? Do all the data sit in the same format?, The best way to do this consolidate all the tabs into one master tab and pull a pivot out of this. Thanks

Hi: Your requirement is not super clear , can't you use a pivot for this? If you are looking to summarise data by Room& Space. If this is not what you are looking for, could you manually show what is your expected results Thanks

Hi: Find the attached. Thanks

Hi: I have not used any VBA code, but Power Query if you go to your power query editor you can follow the steps I have used to get the desired results. Follow this link to know more on power query...

Hi: You can easily do this using power query. Thanks

Hi: May be For Previous Year PY MTD = IF( ISFILTERED('Sheet1'[Order Date]), ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."), TOTALMTD(SUM('Sheet1'[Units Sold])...

Hi: Find the M Code for including more categories let Source = Excel.Workbook(File.Contents("C:\Users\nebusud\Downloads\Concat (3).xlsx"), null, true), Table1_Table = Source{[Item="Table1",Kind="Table"]}[Data], #"Changed Type" = Table.TransformColumnTypes(Table1_Table,{{"Store ID"...

Hi: May be add On Error Resume Next Just before line Cells(i, 20) = Cells(i, 8) / (1 + Cells(i, 9)) Thanks

Hi: If you are interested in a Power Query Solution. let Source = Excel.Workbook(File.Contents("C:\Users\nebusud\Downloads\Sample.xlsx"), null, true), Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data], #"Merged Columns" =...