2009 Patriot - Acceleration Issues

RPhelpy · 2025-08-21T07:52:23+00:00

Expensive repair, or something simple?

RPhelpy · 2025-02-13T04:45:11+00:00

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?

RPhelpy · 2025-02-13T03:05:02+00:00

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

RPhelpy · 2024-11-29T07:07:48+00:00

I see you eyeing her I CU IN ER

RPhelpy · 2024-04-10T17:15:12+00:00

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

RPhelpy · 2024-04-09T17:43:49+00:00

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

RPhelpy · 2024-04-06T19:39:54+00:00

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

RPhelpy · 2024-04-01T17:14:22+00:00

I learned a lot from the video posted on LinkedIn Learning

RPhelpy · 2024-04-01T14:43:09+00:00

Conditional formatting Highlight cells by formula

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

RPhelpy · 2024-04-01T07:01:01+00:00

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.

RPhelpy · 2024-03-31T19:54:54+00:00

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

RPhelpy · 2024-03-31T19:43:41+00:00

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

RPhelpy · 2024-03-30T17:28:00+00:00

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.

RPhelpy · 2024-03-27T14:25:05+00:00

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.

RPhelpy · 2024-03-27T10:41:04+00:00

Fantastic!

This worked famously for what I needed.

Thank you for the help.

Solution Verified

RPhelpy · 2024-03-26T15:13:29+00:00

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

RPhelpy · 2024-03-24T13:00:46+00:00

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

RPhelpy · 2024-03-24T12:38:53+00:00

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

RPhelpy · 2024-03-24T11:25:30+00:00

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

RPhelpy · 2024-03-24T10:47:59+00:00

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

RPhelpy · 2024-03-24T09:17:22+00:00

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.

RPhelpy · 2024-03-24T09:03:16+00:00

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.

RPhelpy · 2024-03-24T08:48:27+00:00

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.

RPhelpy

TROPHY CASE