Search results

Hello Everyone! I have a date column, from which I need to pick the earliest date by using AGGREGATE function. But it doesnt work with the data format. So, I have to convert that date using DATEVALUE and then use aggregate function to get the desired result. Can I use both functions at the same...

Awesome! Thanks -

Works perfectly - thanks again! Quick question though - what is that '2341' in the mid formula?

It works - thanks! Now if I have to add 1 quarter to the subsequent rows - like on cell D10 and onwards - how do I do that?

Hello Everyone! I am converting date column to quarter output. On another sheet, I have a strat that should automatically picks earliest of quarters from the above list. Attached is the spreadsheet that visually explains - Essentially, I need a formula that can pick earliest of quarters from a...

Thanks alot!! You made it look so easy - Needless to say I am new to VB :D

Private Sub Worksheet_Change(ByVal Target As Range) With Application .ScreenUpdating = False .EnableEvents = False End With ay = ActiveCell.Row ax = ActiveCell.Column With Sheets("Dashboard") If ay = 14 And ax = 6 Then y_row = -1...

I did modify to see the dates on Column I but not all years are working -

Worked perfectly, One more query then - I am trying to line up Number of months from Range (B:M) on cell S in vertical format - Essentially, when I change the year in cell P14, it lines up relevant months of the year -

I dont necessarily need those formulas, I'd like to know how to did it -

Thats exactly I was looking to do initially - How did you do it? I dont see any formulas -

I am using Data Validation technique coupled with Name Ranges - Using the link provided by bobhc - thanks for the guidance -

Attached without any links -

Thanks! I will look into it -

Hi, I ran into a situation where I would like to select an item from drop down (Cell H4) and then I would like to show relevant fields on Cells J6 through N6 - For the first row (#6) I was able to do a simple if formula but I have 6 more items in drop down menu and I dont want to write an if...

Thanks! I will go through the link -

Thanks Man!! - You made it look so easy - Do you know how to make X and Y axis dynamic as well, where the markers on axis change according to data?

Sorry Nebu for not clarifying enough - I am trying to figure out two things - - When the chart is plot it automatically avoids null and zeros - - also, drop down menu has different products and each have different datapoints on X axis - So I want to make both axis dynamic - I have attached...

Here's a file with chart -

Hi, I have few cohorts of data with variable data on X and Y axis. I'd like to select those cohorts from drop down menu and would like to see data converting to charts. I have done that part. My Question is how do I avoid blank or NULL cells from inclusion in the chart. Also, is there a way to...

Hi, I am trying to acheive results by sending a text file (sql.sql) to SQL server and fetch the data into excel (64Bit). Any help would be appreciated - Thanks, ' Dim sqlFile As String 'sqlFile = "C:\Users\klakhani\Documents\sql.txt" 'Dim sqlText As String 'sqlText =...

Smooth!! Thanks Luke!

Hello Everyone! I am trying to achiwve desired results by using Index/Match combo. Attached is the sprdsht with example - In essence, I am trying to fetch matching/corresponding date for Column B on sheet 2 by matching the column D on sheet 1 - I will need ColumnB and C on sheet 2 -- Please...

Perfect!! Thanks -

Hi All, I am looking for an answer to below query - CUST IDVALTYPE 15000Jeep 22000Porche 33200 41000 51500 Nissan If I want to get sum of all the values in column B that corresponds to Column C (Blank cells), how should I do that? - I am looking for $4200 - I am dealing with data that has 250K...