bravo

  1. T

    Number of Staff during each 30 minute interval

    Hello Team.. another request.. Been thru similar requests threads..none matched my requirement. Based on the below RAW DATA, I want to know how many staff I have at any given time. SAMPLE RAW DATA: <colgroup><col><col><col><col span="7"></colgroup><tbody> EMP ID Emp Name Supervisor 14-Oct-18...
  2. J

    Mailmerge data layout - vertical or horizontal

    (Apologies of this needs to be in a Word forum, but it is 50% Excel related!) I have some data that I use to create a mailmerge, and in its raw form, the data looks like this: <tbody> hardware support price Alpha a1 £11 Alpha a2 £12 Bravo b1 £22 Bravo b2 £24 Bravo b3 £26 Charlie...
  3. C

    Volume breakdown/distribution to return and receive

    Dear Friends, A have a list of people with volumes to return and others to receive. Ex: Alpha returns 500 Bravo returns 750 Charlie returns 50 Delta receives 200 Echo receives 600 Foxtrot receives 500 I would like to automate the distribution between the parties, resulting in the end on...
  4. M

    countif

    Hi how do I change the formula below to search for multiple matches ie column B3 = "ALPHA / BRAVO / CHARLIE" A3 = ALPHA A4 = BRAVO A5 = CHARLIE A6 = DELTA A7 = ECHO A3 / A4 / A5 need to be flagged "a" A6 / A7 need to be flagged "b" if(COUNTIF(A:A,B3)>0,"a","b")
  5. A

    Complex count and lookup criteria with multiple values - SumProduct???

    Following on from a question I asked a few days ago, I need to calculate the below I have a control Table, indicating whether each Team should be included in the results <colgroup><col><col><col></colgroup><tbody> A B 1 Team Include 2 Team Alpha Yes 3 Team Bravo No 4 Team...
  6. G

    Making data readable.

    My data exists in the following format and I've been asked to summarize it for the sales team. <tbody> 0.25 Austria Alpha 0.50 Austria Alpha 0.75 Austria Alpha 1.00 Austria Bravo 2.00 Austria Bravo 3.00 Austria Alpha 4.00 Austria Charlie 5.00 Austria Charlie 6.00 Austria Bravo...
  7. M

    VBA Vlook up help - Double onerror goto condition

    Hello Friends, I am trying to vlookup on two range, if Name not found in single range then check in second range, if not found in there also then I want result not found. Below is my attempted code. <tbody> A B D E G H Name Score Name Match Score Name Match Score Sachin 105 Sachin...
  8. L

    Retrieving number for calculation: VLOOKUP, LOOKUP, INDEX/MATCH or ????

    First of all, thank you all for taking your time to share your expertise. It is appreciated. This is my first time posting, so apologies if I do something wrong. I've read the FAQ, so hopefully I won't!! I have a worksheet that starts with several columns of numeric data that has about 2000...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top