need help in excel

Hi, I have a column of data that contains multiple numbers in a single cell that are seperated by using the ALT-Enter option like below. I want to look up each of these values and compare to another file that has only 1 value per cell in a column. How can I accomplish this and also how would I...

Hi, I'm given a spreadsheet with no actual dates but only FY and Quarters in two separate columns. How do I convert the Quarter column to reflect it is a date so I may use it in Power BI? Many thanks in advance. Here is a sample: *The actual file is much larger with many more rows and jumps...

Hi I want to find Maximum value from range using "MAXIFS" (max_Range: B column , Criteria Range- A column, Criteria : A2). In that range, Current category sale value should not consider. Logic : Calculated Column C2 = B2 cell should not consider in max_range B2:B15 (that means, Maximum value...

hi all I need help please I have a file with 12 columns and one listbox and one combobox to choose the criterial search I only need to change two things: 1. How to add 17 columns to the listbox instead of 12 columns ? 2. How to make the textbox1 auto-number for each entry ? Thank you everyone

Hi Folks, Can someone please help me out here? Say I have an excel sheet that looks like this: Trainer Site VOC 1 VOC 2 VOC 3 VOC 4 VOC 5 VOC 6 VOC 7 VOC 8 VOC 9 VOC 10 VOC 11 Name 1 Site 1 15/09/2021 15/09/2021 Name 1 Site 1 14/09/2021 17/08/2021...

Hello Everyone, I have following table and need help on sum total of Value 1 column. Value 1 Value 2 100.00 100.00 200.00 500.00 300.00 300.00 400.00 100.00 I am looking for a formula which would return value based on the following criteria: If Value 1 = Value 2 then exclude that...

I have to make the statement based on column A and Column B; Please find the Image for detailed info; is there any formulas to make this statement in excel or VBA. Please help me it will very helpful to me.

Hi Gurus I hope I can explain this correctly. I need to calculate a KPI using %, I got as far as creating the target. Column D is the target of 100%, so if the target is met then the achievement is 100%, I need to calculate the achievement with a max of 200%. Any ideas on how to get this done?

Dear Excel Guru's I need urgent assistance. I need to find the max value on a file number and return the corresponding customer name. My image refers. I am able to find the max value for a file number but unable to return the corresponding customer name. Can someone help me?

Hello Everyone, I have connected Excel with a third party accounting software called Tally through ODBC connection. I use the connection to import data in Excel from Tally. Is it possible to send data from excel to Tally through ODBC connection. Usually i do this process manually. First i save...

Hello Everyone, I have a following data table Batch No. Starting Ending 1 to 10 1 10 11 to 20 11 20 21 to 30 21 30 31 to 40 31 40 I am looking for a formula which would return the matched Batch no. depend on input value. For example, if i put 15 then the result should be...

Hello Everyone, I have a following Data set Batch Invoice No. BT-1 ABC/01/2020-21 BT-1 ABC/02/2020-21 BT-1 ABC/03/2020-21 BT-1 ABC/04/2020-21 BT-1 ABC/05/2020-21 BT-1 ABC/06/2020-21 BT-1 ABC/07/2020-21 BT-1 ABC/08/2020-21 BT-2 ABC/11/2020-21 BT-2 ABC/12/2020-21 BT-2...

Hello everyone, I have two name range lists as follows Fruits Orange Apple Banana Coconut Apricot Vegetable Cucumber Eggplant Pumpkin Squash Tomato I am looking for a solution to use the above lists under data validation with if condition. For example If i Put...

Hello Everyone, I am looking for a way to not allowed "&" character in excel cell. If i try to type "&" character then a message should pop like "Character not allowed". Thanks in advance. Best Regards,

I want following condition to be satisfied in attached sheet image If C5 is greater than zero Put B6=A5, Otherwise Return B6= Value in Cell A Whenever Cell C has number greater than Zero Previously. Please help

<colgroup><col><col><col><col span="2"><col><col span="4"></colgroup><tbody> Site Name Transaction_End Sales_Mix_Ind Payment_Method Payment_method_Std Fuel or CR Fuel CR ES Card Sedgemoor South 20/05/2018 00:09 F Euroshell CRT 2 ES Sedgemoor South 20/05/2018 00:09 C British Pounds...