peter_sss

Hi, I need some help with a formula as I am stuck and can’t think anymore for a solution…let me explain what I need: I have a col A1:A200 with 200 numbers from 1-20 that keeps repeating. In cell B1 I will add a number (5 for example). I need a formula to give me the 3 most common numbers that...

Hi Team, I have input sheet with employees time entries. It has the columns as Company, ID, Name and time entries which are aligned date wise and total break time for each employee in below format. In/out time would be recorded each and every time when an employee swipes the card for in or...

Below is my data which I am able to achieve using this formula...

Hi Guys,Please i have a set of data with specific number of columns i need to copy from an app to excel, once i copy and paste, it pastes all in a single column. Can i get help to convert it to columns and rows as its meant to be? (I have 14 columns with topic) Please help me. The data is like...

Hi all, Good day. Can anyone would help me on how to delete all zeros(0) and put in place the value in one column. Example: A B C D E A 9 0 0 0 0 9 0 10...

I am trying to build a macro which i appreciate any help with.. I have data in sheet 2 which consists of 30 agent Id's. In sheet 1 different agent Ids are entered in column p. I would like a search box that can match and highlight the Agent number entered, if matching any of the agent Id's in...

please give me a formula for the following query [LIST=1] match the two columns A and column C for the same account number [LIST=2]if they match then check for the respective account price columns say column B and column D that whether they providing the same values if the values match then give...

i hve problem with my vba coding..and i dont know hor to reduce it..plz anyone help me..my interface have too many texboxt Private Sub ComboBox1_Change() If ComboBox1 = 1 And ComboBox2 = 1 Then description.Visible = True FlowRate.Visible = True Contaminant1.Visible = True Contaminant2.Visible...