field names

  1. S

    Dynamic conditional replace function

    Hi Power Query gurus out there! I'm going to do my best to explain some help that I need it replacing values, conditionally based on another column's values, while dynamically referencing field names. Here's some sample data: Date Greeting Appreciate Patience (if hold was used) Resolution...
  2. F

    Merge Fields used in word document

    Hi, I have created a word mail merge template from data in an excel document, and I think I'm nearing the 256 column limit - so need to check what exactly I'm using and what (out of the 256 fields) I'm not currently using... What I'm after is some kind of macro that will allow me to open up...
  3. M

    Index Match / lookup using column names and

    Is there a non-array Index Match formula that references field names instead of specific columns and allows for multiple search criteria? Here is my original post that solves the "reference field names" function: Index Match / lookup formula using column names Can I expand on this approach to...
  4. MacroAlan

    Build query from Defs

    I think I've seen what I'm looking for but cannot find it again! I have this huge Crosstab query that shows columns for each month from Year minus 1 through Year plus 2; i.e. 01/01/2017 thru 12/1/2020. I want to gather all the field names into a new query that writes to a new table. I...
  5. K

    The text is too long to be edited.

    Hello, I'm creating a table in access but I keep getting a message says " The text is too long to be edited". Please help me resolve this issue.. Thank you in advance for your help.
  6. M

    Index Match / lookup formula using column names

    Is there a way I can modify this Index Match formula, or use a different formula, so that I can reference by column/field names instead of clicking on specific column references?: =INDEX(source!E:E,MATCH(A2,source!D:D,0)) Instead of source!E:E I'd like to find "DESCRIPTION" in row1 of the...
  7. M

    Excel Field Data pipe delimited with many fields inside

    I have a lot of field data in a row that's in format: Color: Red|Title: Red Shirt|Date: 2015|Medium: cotton|Size: M| Title: Blue Dress|Date: 2014|Price: 55|Size: M| Color:Green| Type: New| Size: G| Title: Green Shirt| Here, in my data, there are many rows with new fields. There are many...
  8. F

    4 Part Extract - Fields are not in the same order

    I am getting a 4 part extract from an enterprise tool which come out in XML, that was irritating but I can work around that, but whats weird is that when I import the data into excel the fields are moving around (see screen shot). No one can seem to either explain to me why this is happening or...
  9. J

    Dynamically Changing Field Names

    I have a query that calculates Current Month and YTD Totals. I would like to have the field names change every month. For Example. I would like the field names to say March 2013 and March YTD 2013 for when I run the data this month and April 2013 and April YTD 2013 when I run next month. Can...
  10. Gingertrees

    VBA: List field names where criteria not met?

    Related to, but sufficiently different from: http://www.mrexcel.com/forum/microsoft-access/657817-feebly-trying-evaluate-several-fields-visual-basic-applications-2.html Classifying business customers: we have programs where each business aims for a Type (Good, Better, Best), and we measure what...
  11. W

    How to use one field to choose another field

    This seems so simple yet I can't get anything to work. I want the value of one field to determine from which column to get a bit of data. I have a table with column names 1, 2, and 3. I have a field called type that contains values 1, 2 and 3. If Type has the value one in it, I want a field...
  12. U

    Finding Field Names of Web Pages

    I am attempting to automate the process of downloading current 401k and IRA data from various websites, however, without knowing the names of the fields I need to populate or the buttons I need to "click", I cannot automate it. What methods are there for determining the field names of webpages?

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top