excel help - asap

[BrieAndChilli]

extracting rows that contain text
i have no idea ow to do this

• I have a workbook with various sheets - an over view sheet and then sheets for each month

• each month has a column (A) with the date, a column (B) with topic and a column (C)with event, there are then lots of other columns but they arent relevant to what I want to do.

• some dates will have data entered (all text and all unique - so cant search for specific words etc) but other dates will be blank

I want to have on the overview sheet a condensed version of each month so it will show like this, only pulling rows that have text entered in the topic column

JANUARY
DATE POST TOPIC EVENT / CONTENT
2nd Booth set up ESMO
5th International womens day inspiring quote
21st event essentials new blog post

My first thought is:

(1) Insert a new column on the overview page
(2) Copy and paste the column you want into the new column.

Or I have misunderstood your query?

i want to enter data into monthly pages and have the overview page automatically update with the info but not include rows that have no data entered
So the monthly tabs have rows 1-31 for each day but i want the overview to only show eg 1st, 5th and 20th with no blank rows in between as they are the only dates that have info entered

Look up Conditional stuff?
IF (A3"", =A3, "")

Or as a workaround, just filter on column A not being blank?

sorry, 10 years out of practice!

I had indeed misunderstood!

But TeenTimesTwo clearly knows what she's about so it looks like you're in safe hands.

You probably do need a helper column (as per pp) and you could use a lookup to match the dates
Ie
Entry actual
Jan January
January January
J January
01/01 January
/01/ January

Then do a
If ( Len (entry) > 0, lookup the date, "" )
Maybe pivot it after?
Or add a count of how many for that month, fixing the first cell so the range expands as you copy down and then lookup january1 january2

Hopefully this gives you some ideas, If.you have any more questions, reply and I will try and look again later (am away on holiday at the mo)

The holding should have been (star)/01/(star)

No I don't!
I usually do complicated excel stuff by reworking something I've done before.