Posts by tradertt

Re: If Data = Negative --> Highlight cell - Without using VBA

Ahhh -- let me try it out - Wonder if there is any more :elegant: ways of doing this as you suggested

Thanks a lot anyway

Re: If Data = Negative --> Highlight cell - Without using VBA

Oh we can use that Thanks

By the way, I tried Conditionally formatting If =A1=A3 then highlight it yellow

But all the cells are referenced to A1

I want it to be A1 = A3
B1 = B3
C1 = C3

etc etc

Re: If Data = Negative --> Highlight cell - Without using VBA

THanks it works

Never knew of that function till today lolz

Can I conditional format so that it actually Highlight cells to todays date? using the function TODAY()?

Hi

Is there a way to highlight a cell if the figure is negative?

=IF(A+B<0, ??? , A+B)

Any function I can use to Highlight a cell as I cannot use VBA

Hi

Instead of sorting by rows

Can I sort horizontally by my headers? --->

Left to right inside of sorting up to down

Hi Guys,

Need some help.

For the weeknum() function, how do I get the week to start on Friday instead of Monday or Sunday?

If it cannot be done, any other ways I can do it?

Thank you

Re: Online Spreadsheet to share between a few friends with password option

Hi Can anyone help?

Hi

Is there anywhere I can set up a Online Excel Spreadsheet to share with a few friends with a password option to prevent people from looking at it?

I need everyone in the group to be able to update and save the spreadsheet

Re: Word Formatting Saving from Webpage

Sorry attachment here

Hi

Does anyone know why my formatting is like that when I saved from a webpage - The words at the right are not wrapped in the page - What can be done in this case?

Thanks

Hi

How can I create a macro for excel to delete rows that have the SAME subject? (delete all duplicates - the price etc on that row may differ but as long as the subject is the same, I was to delete it off)

Thanks

How can I convert dates to Week of the year

Example: 01/11/04 - Week 45
20/12/04 - Week 52

How can I do that?

How can I exclude PKG* from my advance filter?

Re: Show all instances of a certain Data and referencing its weight

Thanks for that.

For advance filter - Is there an easy way to change the data I want to filter instead of having to do a DATA --> FILTER --> ADVANCE FILTER and selecting the list range etc etc...

Is there a way I can just key in the data I want to filter, click something and the filter data will appear below in a different worksheet?

Re: Show all instances of a certain Data and referencing its weight

Lolz

oops

Hi

I have a excel spreadsheet like the one attached.

There are datas available.

I want to Draw out and show ALL the instances of EFGH and show its weight for each instance beside it in a new worksheet

How can I do it?

Does anyone know how to use Advance filter? Any tutorials or videos on it?

Re: Howto Vlookup if it has more than 1 value to display?

Hi Alan,
The countif would not be suitable as I would like to know the exact email of each person if he has 1 or more emails with the email/s listed beside their name.

How would I do a advance filter? Is it like Autofilter?

What if the data table is in a different excel workbook? Can it be done/.

Hi

Please see this spreadsheet attached.

The Vlookup table is in Sheet2 and some people have 2 or more emails.

How can I show in Sheet1 when I do the Vlookup if a person has more than 1 email.

Thanks

Re: Create Macro that Types 1 in a cell and prints then 2 then 3 then 4?

Ok Thanks

Re: Create Macro that Types 1 in a cell and prints then 2 then 3 then 4?

Just for learning purposes - If I want to add another variable for the Number to start with Do I,

Sub XX()
     
    Dim vntTimes As Variant
    Dim intIndex As Integer
     
    vntTimes = InputBox("Enter number of times to print", , 1)
intIndex= InputBox("Enter number to start", , 1)
    If IsNumeric(vntTimes) Then
        For intIndex = intIndex To vntTimes
            ActiveCell.Value = intIndex
            Rem Sheet1.PrintOut
            Application.Wait Now + TimeValue("00:00:01")
        Next
    End If
     
End Sub

Why does it not work? It does not increase the number