Results 1 to 6 of 6

how to list the five last character values in a column

LinkBack
- LinkBack URL
- About LinkBacks
Thread Tools
- Show Printable Version
- Subscribe to this Thread…
Rate This Thread
- Current Rating
- ‎ Excellent
- ‎ Good
- ‎ Average
- ‎ Bad
- ‎ Terrible
Display
- Switch to Linear Mode
- Switch to Hybrid Mode
- Threaded Mode

Threaded View

03-14-2024, 10:15 AM #3
Fluff13

View Profile

View Forum Posts
Forum Guru

Join Date

09-10-2017

Location

Chippenham, England

MS-Off Ver

365

Posts

15,739
Re: how to list the five last character values in a column
Maybe

Formula:

=TAKE(FILTER(A2:A1000,A2:A1000<>""),-5)
Register To Reply

« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

[SOLVED] Values in one column and character separated by multiple word

By JaffarAhamed in forum Excel Formulas & Functions

Replies: 3
Last Post: 05-23-2023, 10:30 AM
[SOLVED] List all unique 5 character combinations from a single column list of 28 characters

By Book Guy in forum Excel Programming / VBA / Macros

Replies: 6
Last Post: 02-04-2023, 12:23 PM
[SOLVED] Convert Column Into Comma-Separated List: Getting Around Character Limit

By splendidus in forum Excel Programming / VBA / Macros

Replies: 6
Last Post: 08-14-2020, 10:36 AM
Extract list of values from one column based on values in another column

By The Speculator in forum Excel Formulas & Functions

Replies: 4
Last Post: 07-21-2019, 11:22 PM
[SOLVED] Adding a character to column if column doesn't already end in same character

By taylorsm in forum Excel Programming / VBA / Macros

Replies: 7
Last Post: 02-09-2018, 10:32 PM
Insert a blank row ABOVE a certain character in a column when the character can repeat

By theglitch in forum Excel Programming / VBA / Macros

Replies: 3
Last Post: 11-08-2012, 05:01 PM
How do I search for a character in column 1 and display another character in column 2

By anon in forum Excel General

Replies: 4
Last Post: 01-21-2011, 08:44 AM

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT -4. The time now is 12:59 AM.

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1