Latest activity

What's new Featured content New posts New profile posts Latest activity

A

alexiaamber replied to the thread Number of text cells by color.

Hi Dave, Yes, this can be done with VBA, but the important point is that Excel’s normal COUNTIF/COUNTIFS functions don’t directly count...

Yesterday at 4:30 AM
ssoraj242 commented on SSO FILE's profile post.

askMID is a central online database service used in the United Kingdom to check the insurance status of road vehicles. It provides...

Sunday at 9:04 AM
shamimarita replied to the thread nested if statement.

Hello Wandy, You can combine Annual Check and Monthly Check using the OR function, since both use the same conditions for the date in...

Saturday at 2:00 AM
shamimarita replied to the thread Calculation based on lookup values.

Hi snowbunny99, You can handle the duplicate PO# rows by allocating the received quantity to each ordered row sequentially instead of...

Saturday at 1:57 AM
shamimarita replied to the thread Comparing percentage values against constants, less than, greater than, and ranges.

Hello bevtyler, Yes, you can simplify this quite a bit instead of continuing with multiple nested IF statements. If the criteria are in...

Saturday at 1:55 AM
K

Korkus commented on 99Studio's profile post.

This is a clear and professional introduction to 99Studio's architectural design. Their commitment to creating functional and elegant...

Saturday at 12:20 AM
K

Korkus commented on mrjone's profile post.

For anyone in the marketing space, it's always wise to research platforms and services before committing. You might find it helpful to...

Saturday at 12:16 AM
K

Korkus commented on MichaelG's profile post.

Anche io apprezzo le piattaforme con un'interfaccia pulita e funzionale, che permettono di rilassarsi senza complicazioni. Quando voglio...

Saturday at 12:10 AM
K

Korkus commented on SSOID's profile post.

Great to connect with another IT professional. Your work with the Raj government's IT department sounds fascinating. If you're ever...

Saturday at 12:02 AM
B
bevtyler posted the thread Comparing percentage values against constants, less than, greater than, and ranges in Excel Formulas.

I have two small tables where I need to compare percentages in columns E, F, G to the values/ranges in A, B, C. Is there an easier way...
Friday at 2:51 AM
S
snowbunny99 posted the thread Calculation based on lookup values in Excel Formulas.

Hi everyone, Could you please help me with a formula to calculate the Outstanding Qty in column D? There are 2 tables: the left one is...
Aug 5, 2026
W

Wandy posted the thread nested if statement in Excel Formulas.

i have this issue if (C2="annual check") { if (D2<TODAY() print expired; else if (D2<=TODAY()+7 print expiring soon; else print...

Aug 4, 2026
shamimarita replied to the thread Add PassCode requirement for one particular Macro in a Spreadsheet.

Hello Almadolam, You can place the column-unhiding commands directly inside the password-protected macro. Try the following code: Sub...

Aug 3, 2026
A

almadolan posted the thread Add PassCode requirement for one particular Macro in a Spreadsheet in Macros & Excel VBA.

Hello, hivemind! It's been awhile and I need some guidance on using a little VBA to add a PassCode for a spreadhseet. Only certain...

Aug 2, 2026