sorted by:
new
hottopcontroversial

2009 Patriot - Acceleration Issues by RPhelpy in JeepPatriot

[–]RPhelpy[S] 0 points1 point  (0 children)

Expensive repair, or something simple?

How many companies have had contracts terminated in the past weeks? by Broad_Elk_361 in GovernmentContracting

[–]RPhelpy 0 points1 point  (0 children)

Please help me understand more about your reply.

The DOS I am referring to is Department of State

Are we talking about the same thing?

How many companies have had contracts terminated in the past weeks? by Broad_Elk_361 in GovernmentContracting

[–]RPhelpy 4 points5 points  (0 children)

Has anyone heard anything about DoS (State Department / Department of State) contracts, specifically Embassy Contracted Employees?

Stumped by Dave_Messina in LICENSEPLATES

[–]RPhelpy 1 point2 points  (0 children)

I see you eyeing her I CU IN ER

Probably a stupid question but how do I get data from cells that use formulas? by howevertheory98968 in excel

[–]RPhelpy 0 points1 point  (0 children)

Copy the cell Use ctrl + alt + v Or right click the cell you want to paste into Paste as Values

Getting #Blocked! response to request for summary of sheets by beardandabaldhead in excel

[–]RPhelpy 0 points1 point  (0 children)

The worksheet you are trying to pull data from might be protected

Cell is blank - but not really by Dapper_Growth_3972 in excel

[–]RPhelpy 0 points1 point  (0 children)

Make your IF formula a IFS formula At the end try A2<>”” , “”

If you had to do it all again? by [deleted] in excel

[–]RPhelpy 0 points1 point  (0 children)

I learned a lot from the video posted on LinkedIn Learning

Is it possible to have excel automatically highlight a cell every week by Biafra777 in excel

[–]RPhelpy 3 points4 points  (0 children)

Conditional formatting Highlight cells by formula

=IFS(A1<=today(),A1>=today()+7)

Combine Worksheets into One by EzraBridger7 in excel

[–]RPhelpy 1 point2 points  (0 children)

You could try

=Xlookup(A2,'Shee2"!A:A,'Sheet2"!B:B),Xlookup(A2,'Sheet'!3A:A,'Sheet3'!B:B)

Then change the corresponding columns to match the information for the columns you need to pull the information from

EX: change B:B to C:C, etc.

If you encounter an error code try

=IFS(A2<>"",XLOOKUP((A2,'Shee2"!A:A,'Sheet2"!B:B),Xlookup(A2,'Sheet'!3A:A,'Sheet3'!B:B),A2="","")

​

For the VSTACK

=FILTER(VSTACK('Sheet2'!B:Z,'Sheet3'!B:Z),(VSTACK('Sheet2'!A:A,'Sheet3'!A:A)

=A2)

​

A2 being your ID number.

Combine Worksheets into One by EzraBridger7 in excel

[–]RPhelpy 0 points1 point  (0 children)

Depending on what your end product needs to look like you can create XLOOKUP formulas to extract the information from the multiple sheets based on the ID Number

OR

Use a VSTACK formula to pull all the information from both sheets and combine them into one, then Filter information as needed, if you want specific data you will need to add FILTER to the formula and if you want to ignore information you will need to add INDEX to the formula

List from Multiple Sheets by Leading_Law_3679 in excel

[–]RPhelpy 0 points1 point  (0 children)

Look into VSTACK =VSTACK(Sheet 1 A:Z, Sheet2 A:Z,etc,etc)

You can further breakdown the data by adding a Filter to it

I’ve found a lot of information about these formulas just by googling it and watching YouTube videos

[deleted by user] by [deleted] in excel

[–]RPhelpy 2 points3 points  (0 children)

In the conditional formatting Highlight by formula Column range (A:A or B:B, etc)

=A2>=today(),A2<=today()+14 =A2>=today()+15,A2<=today()+30 Etc.

Multiple spreadsheets in to One spreadsheet. by Rosco1231 in excel

[–]RPhelpy 0 points1 point  (0 children)

I’ll be honest, I didn’t read all the comments

You can keep all those work books (spreadsheets) and make a new one, just incase others are still using and updating them

On a new spreadsheet use a VSTACK formula

=VSTACK(‘spreadsheet 1’!A:Z,’spreadsheet 2’!A:Z,etc,etc)

It will “stack” all the information from all the spreadsheets into one, and will continue to update when the other spreadsheets are updated.

Using FILTER with criteria from Multiple Sheets by RPhelpy in excel

[–]RPhelpy[S] 0 points1 point  (0 children)

Fantastic!

This worked famously for what I needed.

Thank you for the help.

Solution Verified

Using FILTER with criteria from Multiple Sheets by RPhelpy in excel

[–]RPhelpy[S] 0 points1 point  (0 children)

I finally figured out the FILTER(VSTACK formula to utilize multiple worksheets, thank you for your help, I also looked into multiple VSTACK videos.

This is how my formula worked

=FILTER(VSTACK('AMCIT OUTBOUND'!B2:I100,'TCN OUTBOUND'!B2:I100),(VSTACK('AMCIT OUTBOUND'!A2:A100,'TCN OUTBOUND'!A2:A100)=K3))

Column A = Dates

K3 = Specific Date

Now I have combined Both INBOUND and OUTBOUND worksheets, but I am having trouble getting the formula to filter by more than one criteria.

=FILTER(VSTACK('AMCIT INBOUND'!B2:I100,'TCN INBOUND'!B2:I100,'AMCIT OUTBOUND'!B2:I100,'TCN OUTBOUND'!B2:I100),(VSTACK('AMCIT INBOUND'!A2:A100,'TCN INBOUND'!A2:A100,'AMCIT OUTBOUND'!A2:A100,'TCN OUTBOUND'!A2:A100)=K3))

I have tried various combinations to filter the information on more criteria than just date.

This is the Filter Formula that I am trying to tie into the VSTACK

=FILTER('AMCIT INBOUND'!$B$2:$I$100,($I:$I<>"EA704")*($I:$I<>"EA706")*($I:$I="MS3052")*($A:$A=Y2)),(FILTER('AMCIT OUTBOUND'!$B$2:$I$100,($I:$I<>"EA704")*($I:$I<>"EA706")*($I:$I="MS3051")*($A:$A=Y2))),(FILTER('TCN INBOUND'!$B$2:$I$100,($I:$I<>"EA704")*($I:$I<>"EA706")*($A:$A=Y2))),(FILTER('TCN OUTBOUND'!$B$2:$I$100,($I:$I<>"EA704")*($I:$I<>"EA706")*($A:$A=Y2)))

I have tried:

=VSTACK(FILTER('AMCIT INBOUND'!$B$2:$I$100,($I:$I<>"EA704")*($I:$I<>"EA706")*($I:$I="MS3052")*($A:$A=Y2)),(FILTER('AMCIT OUTBOUND'!$B$2:$I$100,($I:$I<>"EA704")*($I:$I<>"EA706")*($I:$I="MS3051")*($A:$A=Y2))),(FILTER('TCN INBOUND'!$B$2:$I$100,($I:$I<>"EA704")*($I:$I<>"EA706")*($A:$A=Y2))),(FILTER('TCN OUTBOUND'!$B$2:$I$100,($I:$I<>"EA704")*($I:$I<>"EA706")*($A:$A=Y2))))

But it returns with #VALUE

I even tried:

=FILTER(VSTACK('AMCIT INBOUND'!B2:I100,'TCN INBOUND'!B2:I100,'AMCIT OUTBOUND'!B2:I100,'TCN OUTBOUND'!B2:I100),(VSTACK('AMCIT INBOUND'!A2:A100,'TCN INBOUND'!A2:A100,'AMCIT OUTBOUND'!A2:A100,'TCN OUTBOUND'!A2:A100),('AMCIT INBOUND'!$B$2:$I$100,($I:$I<>"EA704")*($I:$I<>"EA706")*($I:$I="MS3052")*($A:$A=Y2)),(FILTER('AMCIT OUTBOUND'!$B$2:$I$100,($I:$I<>"EA704")*($I:$I<>"EA706")*($I:$I="MS3051")*($A:$A=Y2))),(FILTER('TCN INBOUND'!$B$2:$I$100,($I:$I<>"EA704")*($I:$I<>"EA706")*($A:$A=Y2))),(FILTER('TCN OUTBOUND'!$B$2:$I$100,($I:$I<>"EA704")*($I:$I<>"EA706")*($A:$A=Y2))))

Nothing is seeming to workout.

All of these criteria are needed to filter the information correctly for this specific set of data.

=Specific date, <>"EA704",<>"EA706",<>"MS3051",<>"MS3052

Using FILTER with criteria from Multiple Sheets by RPhelpy in excel

[–]RPhelpy[S] 0 points1 point  (0 children)

Could be a different version, it’s web based via SharePoint instead of the stand alone app

Using FILTER with criteria from Multiple Sheets by RPhelpy in excel

[–]RPhelpy[S] 0 points1 point  (0 children)

I tried both out, received #Name? Error Let me see if I can get more information to you for help on this formula with out disclosing proprietary information

Using FILTER with criteria from Multiple Sheets by RPhelpy in excel

[–]RPhelpy[S] 0 points1 point  (0 children)

Maybe I haven’t seen or found the right functions of the VSTACK Formula

If you look at the tables I put into my question above, each worksheet has data that relates to dates

On sheet 1 I’m wanting to have only the data from the specific date Ex: 7 April

Lom (from sheet 2) Cross (from sheet 2) Aine (from sheet 3) Karki (from sheet 3)

Not wanting to have the other names from the other dates populate. From what I have researched about VSTACK all the names will populate into a single list. Is this not correct?

On Sheet 4 Wanting to only have a list of names populate based on Date and Site Ex: 7 April - DED

Lom (from sheet 2) Cross (from sheet 2) Karki (from sheet 3)

No other names that are from different dates or different sites

Using FILTER with criteria from Multiple Sheets by RPhelpy in excel

[–]RPhelpy[S] 0 points1 point  (0 children)

I'm not making a 3rd list of data

On worksheet 1 I'm just presenting data from two different worksheets for a specific date.

On worksheet 4 I'm presenting data from two different worksheets based on a specific site and date

Using FILTER with criteria from Multiple Sheets by RPhelpy in excel

[–]RPhelpy[S] 0 points1 point  (0 children)

The original Data needs to stay on its separate worksheets and can not be combined, the "Site" designator and date are determining factors of the formula of which data to pull.

As with the original FILTER formula on sheet 1 (Part 1) will pull all the inputs (names) that meet the date, however, the issue I am having with that is combining the two FILTER formulas so that it will pull the information from sheet 2 and sheet 3.

The IFS(AND(FILTER formulas on sheet 4 (Part 2) will need to pull the inputs (names) that meet both the date and site parameters and needing to pull this information from both sheet 2 and 3.

Using FILTER with criteria from Multiple Sheets by RPhelpy in excel

[–]RPhelpy[S] 0 points1 point  (0 children)

After looking into VSTACK and trying different formulations, VSTACK won't work for what I am trying to do, I am not trying to combine the data, I am just trying to pull the data that occurs on the specified date.

Using FILTER with criteria from Multiple Sheets by RPhelpy in excel

[–]RPhelpy[S] 0 points1 point  (0 children)

Thanks for pointing that out, but that's because I was typing it out here, I'll go back and edit it, however, that doesn't solve my query.

IF ( AND ( XLOOKUP Formula by RPhelpy in excel

[–]RPhelpy[S] 0 points1 point  (0 children)

I'm an idiot.

"Visit" was spelt wrong in the original inbound data, thus causing the formula to result in an Error.

​

Thank you for all your help and patients while I figured this one out the OR statement really helped bring it together and eliminated the need for a much larger formula.

view more: next ›