multiple column

  1. Emanuele

    Multiple Column and string extract

    Hi guys, I would like to know if there is a way to add more than 1 adjacent column for the presented code that I found on Internet and that Fluff helped me to modify in this Post Furthermore it's possible to apply a string extract (for example, extract the first 4 and the last 4 characters and...
  2. Emanuele

    Multiple column and String extract VBA

    Hi guys, I would like to know if there is a way to add more than 1 adjacent column for the presented code that Fluff helped me to modify in this Post Furthermore it's possible to apply a string extract (for example, extract the first 4 and the last 4 characters and put them in different column)...
  3. G

    2 Consecutive Cells match (Column A&B) match 2 other Consecutive cells (Column D&E), copy entry in Column C to Column F

    Hi Everyone, First time posting so hopefully this is clear. I need a formula that can help find and populate an entry when 2 consecutive cells in the same row match 2 other consecutive cells in other columns. i.e. Cell A2 = John Cell B2 = Smith Cell C2 = Blue Cell D13 = John Cell E13 =...
  4. M

    How to sum multiple column values based on multiple date ranges and resolve into date range summary?

    Hi excel help community, I have a sheet that collects our planned scaffold tower quantities by type for each bridge we have with an associated date range of use. I would like to sum scaffold type in use by month (see below) to enable us to produce a histogram of scaffold type over several...
  5. A

    COUNTIF not working

    Hello, hope for anyone that can help. Basically, I have input a COUNTIF function for Column B such as =countif(B:B,B2=1). A popup will occur if there are any duplicate values. When I entered this and run, it worked as intended. Then on a different column, I used a Vlookup to carry out another...
  6. P

    creating multiple radar graph from multiple column from single worksheet

    I worksheet of 500+ column. I need to create radar 1 graph for each 20 column.Each column has 72 rows.means obviously 1 radar for 1 column. each chart has 20 columns/ radars. from 1 to 20 column 1 chart will be there next chart is for 21 to 40 column. 3rd chart for 41 to 60 column and so on...
  7. R

    One Column into 4 Columns without Text to Columns method

    I need help on how to take one column with an address and make it into multiple columns without using the Text to Columns method. My example address looks like this: <tbody> 2000 STREET ADDRESS DR CITY, STATE 20000 </tbody> After I copy and paste that into a multiple column cell, I would...
  8. D

    filtering multiple columns in excek

    Hey guys, I'm trying to filter a report, but I want to filter multiple columns. for example, in column 1 I want to show the values "base" and "connect" and in column 2 I want to show the rows that contain "subgroup". however, the issue is, that rows that have base or connect in the first row...
  9. S

    Conditional formatting between two worksheets

    Hi - I have a large spreadsheet with multiple tabs in it. I'm looking for a conditional formatting solution for the following - I'll explain: Say in my worksheet I have Tab1 and Tab2. Tab1 has a list of customers we work with based on submissions they send in. on Tab2, I keep track of these...
  10. W

    VLOOKUP multiple columns

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]-->Hi Folks, I wanted to know what the formula would be when using a VLOOKUP formula for multiple columns from another sheet. This is the formula I have however, I’m getting an...
  11. C

    Using column values for Row heading, when using multiple columns in Pivot Table

    Friends, I am trying to use PivotTable for a function that can be done in HLookup, but I am hoping can be done much faster in Pivot Table. I have five (5) related columns that all have the values of Positive, Neutral, Mixed, Negative, and NA. I am wanting these values to be the Row Headings in...
  12. L

    VBA to Extract unique values from multiple columns in to one column

    Hello, I'm a new member and I'm not entirely sure how this forum works and where to post questions. I've been searching on this site as well as online and did manage to find some info, but none of them seem to work or doesn't apply. Issue: I have a workbook with multiple tabs; each tab does...
  13. R

    How to Apply VBA Macro Code to Multiple Columns

    Hello! I have this code below applying to one column right now so that I can select multiple keywords from a data validation drop down. I need this to apply to multiple columns. I found a similar query on here but I couldn't get the code to work for me. Please help, see below. I want it to...
  14. A

    VBA (Non VBA preferred but don't think possible) Copy entire row multiple column criteria question

    Evening MrExcel Community, Well now it appears it's morning. I'm fairly decent with most things non VBA on excel but the VBA side I don't really know much about. Apparently this is my next area to learn. I have an excel sheet that I update the main info from another database by deleting the...
  15. K

    SUMIFS 1 criteria 36 columns URGENT

    Trying to add 36 columns based on 1 criteria, and return the result. example: <tbody> product status units/$ wk 1 wk 2 total units total $ wk 1 wk 2 ttl a allocated 2 0 1 1 $10 b released $20 c allocated 7 2 3 5 $50 d released $70 </tbody> area from units/$ to ttl...
  16. J

    VLOOKUP for multiple items over differnet sheets

    Hello all I am new here so im sorry if this has been asked and answered but this is what I am looking for.Currently I am using VLOOKUP like this =IF($A8="","",(VLOOKUP($A8,MASTER!$A$1:$G$1500,6,FALSE)))I have changed my master sheet to allow conversions so now I enter the master sheet like...
  17. D

    TOP 5 From Multiple Rows

    <tbody> Labour Cost Cleaning 200.58 Travel Time 489.56 Wet Time 55.00 Set- UP 855.00 Operating Equipment 780.00 Spotter 200.00 Supervision 1200.00 </tbody> I need a formula that gives me the top 5 values in Col B and then Displays them with the appropriate Value in Col A As such...
  18. G

    Excel 2007: List Box (ActiveX Control) with multiple columns?

    I am working on an electronic version of an existing paper form. The user must be able to make multiple selections from 18 choices. Each choice has a corresponding check box. I have a List Box (ActiveX Control) with the following properties set: ListStyle: 1 - fmListStyleOption MultiSelect: 1...
  19. T

    Conditional formatting accross more than one collumn. dependant on specific word

    Hi, I have been building a database for my small business for the book keeping I am currently using: Windows 7 64bit Microsoft Excel 2010 Basically I have a price column and a Income/Expense column. I want the currency value in the price column to be red text if the word in the Income/Expense...
  20. S

    Sumifs with several criteria

    I am trying to write a formula that does the following: I have data with say 200 company names, their interest income each year, the year the income was generated, and who they received interest income from (one of 200 other companies). I want to sum the interest income (which is in 3 different...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top