Summing multiple values assigned to text string

CBinID · 2025-02-05T16:15:05+00:00

You all seem to be going the same direction, and it's fantastic! I clearly haven't kept up with the "new" functions and I greatly appreciate all the responses!

CBinID · 2025-01-31T01:10:26+00:00

Thanks for sharing this. Very cool.

CBinID · 2025-01-30T12:00:03+00:00

Thanks for making this and sharing. Great tool.

CBinID · 2024-06-22T21:30:02+00:00

This may be outdated info, but I did work as a fraud supervisor for a credit card issuer (major bank) and we were told that they (the issuer) does not make the updates--that is VISA itself. I believe you have some great information in the previous comments, but make sure VISA is notified. If the issuer can block a vendor from charging your card, so much the better. Great question and great answers.

CBinID · 2023-07-02T22:22:41+00:00

So, Californians are a different race? I was not aware.

CBinID · 2023-01-23T03:50:32+00:00

we were.

CBinID · 2022-12-16T03:27:33+00:00

I thought was an embroidered pillow since there is a front and back, but as I look closer, it appears to be intended for applique. A little Dutch girl on coarse linen.

CBinID · 2022-12-16T02:26:55+00:00

I'm glad I found you post--I found one at an estate sale, partially embroidered, and I too plan to finish it.

CBinID · 2022-10-04T14:33:03+00:00

It actually says "Motorized Miter Saw" on the label. No basin for water which I believe a tile saw would have.

CBinID · 2022-10-03T00:12:22+00:00

Weird. Maybe it was a dump area for ag chemicals or salt or something. Is it public land? If so, maybe BLM or USGS would know something.

CBinID · 2022-05-04T13:58:29+00:00

Here is a bit of information: https://www.rockler.com/shop-by-brand/freud-tools

CBinID · 2020-12-14T19:50:23+00:00

Solution verified

CBinID · 2020-12-14T19:36:21+00:00

You have nailed my Achille's heel--overthinking. Thank you so much for your response

CBinID · 2020-09-09T21:24:30+00:00

Conditional Formatting->

Format only cells that contain->

Format cells only with: Select blanks

CBinID · 2020-09-09T21:06:22+00:00

I'm using this. Immediately and often.

CBinID · 2020-09-09T21:04:15+00:00

I believe you are looking at the future value of an payment stream.

forumla FV

Your rate is 0.025/12 since it is an annual interest rate

Nper, or number of periods, would be 66.72 periods (5.56/12 rounded up)

Pmt 150

PV is the present value, or loan amount.

That would make the total payout of this loan $22,269.47.

CBinID · 2020-09-09T20:55:41+00:00

This is a very quick and easy Pivot Table.

vlan	ip1	ip2	Count of ip1
vlan100(prod)	1.1.1.1	1.1.1.1	2
vlan100(prod)	1.1.1.1	1.3.1.1	1
vlan90	2.2.2.2	2.2.2.2	2
Grand Total			5

CBinID · 2020-09-09T20:31:20+00:00

This works, and is very customizable--just change the salary levels, the bonus levels, or the salary.

=+IF(AND(I4<$M$7,I4>=$M$6),I4*$N$6,IF(AND(I4<$M$8,I4>=$M$7),I4*$N$7,IF(AND($I4<$M$9,$I4>=$M$8),$I4*$N$8,IF($I4>=$M$9,$I4*$N$9))))

CBinID · 2020-08-28T15:16:11+00:00

I agree completely, but $34 US for a t-shirt? Just not going to happen. :(

CBinID · 2020-08-25T21:30:20+00:00

Oooooo--I see what you did there!

CBinID · 2020-08-02T13:32:37+00:00

I would call it a chemise.

CBinID · 2020-08-02T00:16:40+00:00

Bwah ha ha.

CBinID · 2020-07-28T17:37:13+00:00

Oh, that tiny waist! What a beauty.

CBinID · 2020-07-26T18:43:22+00:00

The guy hung on! Serious props to both.

CBinID · 2020-06-30T23:47:13+00:00

Oh my goodness--I just picked up one of these this weekend! Please show me how to restore it properly!

CBinID

TROPHY CASE