Search Results - Excelguru.ca

Add data to and existing table using named ranges.

Started by NWVR, 2022-05-04 06:30 PM

Replies: 2
Views: 1,638

Last Post By:: Last Post: 2022-05-11 12:58 PM; by NWVR

Forum:
VBA Programming

Problem with imported data table

Started by Wallybok, 2021-10-22 12:31 PM

Replies: 5
Views: 1,948

Last Post By:: Last Post: 2021-10-23 11:03 PM; by Wallybok

Forum:
Other General Questions

Conditionally filling a table based on non-unique information from another table

Started by Joecam, 2021-04-11 12:04 PM

Replies: 9
Views: 6,817

Last Post By:: Last Post: 2021-04-11 03:35 PM; by AliGW

Forum:
Formulas

Create Multiple Pivot tables automatically or quickly

Started by MsDavid, 2021-01-17 08:17 PM

Replies: 5
Views: 3,608

Last Post By:: Last Post: 2021-01-19 10:14 AM; by MsDavid

Forum:
VBA Programming

Best method to create training log?

Started by ExcelHelpNecessary, 2021-01-14 06:59 PM

Replies: 2
Views: 2,824

Last Post By:: Last Post: 2021-01-16 05:54 AM; by alansidman

Forum:
Other General Questions

Rename column on consulting edit

Started by Coribien, 2020-06-12 12:28 PM

Replies: 7
Views: 4,826

Last Post By:: Last Post: 2020-06-12 07:54 PM; by NormS

Forum:
Other General Questions

Remove rows above a cell with certain contents?

Started by Charley, 2019-04-09 12:31 AM

Replies: 2
Views: 2,080

Last Post By:: Last Post: 2019-04-09 03:22 PM; by BernardBrussels

Forum:
Power Query (Get & Transform) & M code

Count column in Filtered Table

Started by szchris384, 2018-10-05 11:57 PM

Replies: 7
Views: 4,097

Last Post By:: Last Post: 2018-10-10 11:04 PM; by szchris384

Forum:
Formulas

can I create slicer connections to filter both pivot and regular tables?

Started by joe1250, 2018-02-02 09:30 PM

Replies: 7
Views: 14,249

Last Post By:: Last Post: 2018-03-01 04:40 PM; by joe1250

Forum:
PivotTables

I need help with pivot table

Started by TuanPham, 2017-12-17 08:23 PM

Replies: 1
Views: 3,636

Last Post By:: Last Post: 2017-12-18 09:33 AM; by Pecoflyer

Forum:
PivotTables

Can more than one query update one table?

Started by Charley, 2017-11-13 06:01 PM

Replies: 2
Views: 2,880

Last Post By:: Last Post: 2017-11-14 02:03 PM; by Charley

Forum:
Power Query (Get & Transform) & M code

Finding a value with horizontal and vertical parameters

Started by willian2142, 2017-08-28 03:34 PM

Replies: 1
Views: 2,505

Last Post By:: Last Post: 2017-08-28 07:52 PM; by NBVC

Forum:
Formulas

Reporting Items in every month they were open, based on creation and closure date.

Started by The_excell_initiate, 2017-04-05 12:54 PM

date difference, date interval, pivot, table

Replies: 1
Views: 2,631

Last Post By:: Last Post: 2017-04-10 11:44 PM; by p45cal

Forum:
PivotTables

Question Grouping rows in Table

Started by Dan Bliss, 2017-03-02 03:54 PM

Replies: 2
Views: 2,429

Last Post By:: Last Post: 2017-03-03 06:37 AM; by Dan Bliss

Forum:
Other General Questions

Looking up value with 2 name match + row or column number.

Started by bilegt, 2017-01-24 05:18 AM

Replies: 4
Views: 3,382

Last Post By:: Last Post: 2017-01-24 03:56 PM; by Canapone

Forum:
Formulas

Power Query to combine file path with file name and add cell reference to extract inf

Started by Shyland, 2016-12-15 04:24 PM

concantenate, hyperlink, power query, table

Replies: 5
Views: 6,779

Last Post By:: Last Post: 2016-12-20 03:46 PM; by Shyland

Forum:
Power Query (Get & Transform) & M code

Pivot table showing results from multiple source columns

Started by NiranNiran, 2015-11-19 10:13 AM

Replies: 1
Views: 3,029

Last Post By:: Last Post: 2015-11-23 09:21 AM; by NiranNiran

Forum:
PivotTables

Pivot table showing results from multiple source columns

Started by NiranNiran, 2015-11-19 10:05 AM

Replies: 0
Views: 2,756

Last Post By:: Last Post: 2015-11-19 10:05 AM; by NiranNiran

Forum:
PivotTables

Need a Formula to Auto populate dates

Started by AudreyKay, 2015-11-04 11:57 PM

Replies: 3
Views: 3,864

Last Post By:: Last Post: 2015-11-07 04:46 PM; by Ron Coderre

Forum:
Formulas

Conditional Formatting in cell or column, contained in a table in the sheet

Started by niteshgoel, 2015-08-24 06:37 AM

cell, conditional formatting, excel, table

Replies: 2
Views: 3,242

Last Post By:: Last Post: 2015-08-24 06:49 PM; by hossat

Forum:
Other General Questions

How can I link to a large table in another excel file ?

Started by Els G, 2014-06-24 07:57 AM

Replies: 8
Views: 9,711

Last Post By:: Last Post: 2014-07-03 03:58 PM; by p45cal

Forum:
PivotTables

Updating a cell from a table entry

Started by calicjhw, 2013-12-12 06:25 AM

Replies: 1
Views: 3,140

Last Post By:: Last Post: 2013-12-12 01:42 PM; by NBVC

Forum:
PivotTables

Rolling UP Table and Values

Started by Kamusksn, 2013-03-26 10:43 PM

Replies: 1
Views: 2,557

Last Post By:: Last Post: 2013-03-27 12:57 PM; by NBVC

Forum:
Other General Questions

importing data from SQL Server via data connection

Started by muzac, 2013-03-01 09:04 PM

Replies: 0
Views: 3,704

Last Post By:: Last Post: 2013-03-01 09:04 PM; by muzac

Forum:
Data Exchange Using SQL

Search:

Search: Search took 0.00 seconds.

Add data to and existing table using named ranges.

Problem with imported data table

Conditionally filling a table based on non-unique information from another table

Create Multiple Pivot tables automatically or quickly

Best method to create training log?

Rename column on consulting edit

Remove rows above a cell with certain contents?

Count column in Filtered Table

can I create slicer connections to filter both pivot and regular tables?

I need help with pivot table

Can more than one query update one table?

Finding a value with horizontal and vertical parameters

Reporting Items in every month they were open, based on creation and closure date.

Question Grouping rows in Table

Looking up value with 2 name match + row or column number.

Power Query to combine file path with file name and add cell reference to extract inf

Pivot table showing results from multiple source columns

Pivot table showing results from multiple source columns

Need a Formula to Auto populate dates

Conditional Formatting in cell or column, contained in a table in the sheet

How can I link to a large table in another excel file ?

Updating a cell from a table entry

Rolling UP Table and Values

importing data from SQL Server via data connection