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...
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...
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...
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...
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.
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...
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...
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...
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...
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...
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...
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 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.