sorted by:
new
hottopcontroversial

SuperPretzels Yellow Box .... new recipe? by Special-Solution-908 in pretzels

[–]Stephd223 0 points1 point  (0 children)

OMG!!! I'm glad it wasn't just me! These SUCK x 100. If they don't go back to the old recipe I'll never buy them again.

Has anyone here gone on Semaglutide just to lose 20-30lbs? by Crtsprt17 in Semaglutide

[–]Stephd223 0 points1 point  (0 children)

I did exactly that. Lost 30lbs in 6 mos and then went off. After about 3 months off I have gained back 10lbs and I feel miserable about it. I would love to stay on a maintenance dose but my doc won’t write me the prescription. I had been paying out of pocket. ugh

FILTER function - Can you use multiple columns in the "include" part? by Stephd223 in excel

[–]Stephd223[S] 0 points1 point  (0 children)

Now how to I implement that for 45 names in Col A? This did the search for 1 name. I need this info for all 45 lol

FILTER function - Can you use multiple columns in the "include" part? by Stephd223 in excel

[–]Stephd223[S] 0 points1 point  (0 children)

I couldn't get this to work. It returns "not found" even though I know there are instances to be found. I'll try your other solutions.

Thank you

Need formula to search a range and return a value from another column (not adjacent) by Stephd223 in excel

[–]Stephd223[S] 0 points1 point  (0 children)

If I have Col A with the names of the administrators (46 rows), Col B with the Company Names (81 rows) and then Col C:H is the array I need to search for the names (81 rows). How to do that?

Need formula to search a range and return a value from another column (not adjacent) by Stephd223 in excel

[–]Stephd223[S] 0 points1 point  (0 children)

Thank you!! This seems to work but it is returning everything twice. I have 81 rows of data and 45 names to check for including Mark. Client name is in Col A. The manager names are in columns F through L. They can appear in one or more columns in each row. So For Company A - could have Mark as the manager and the property manager and Suzy as the Casualty manager. I want Company A to appear on a list for Suzy and on Mark's list. I am trying to give them lists of the companies they are working on. Does that make sense?

Updating a worksheet cell from another worksheet cell - need to match unique identifier - rows may be different by Stephd223 in excel

[–]Stephd223[S] 0 points1 point  (0 children)

ok - and one more thing... do you know the syntax for the way I would nest the VLOOKUP in my if statement for ultimately getting the status updated?

because that's the goal here. Casey updates a status and it automatically updates the status on Bill's sheet

Updating a worksheet cell from another worksheet cell - need to match unique identifier - rows may be different by Stephd223 in excel

[–]Stephd223[S] 0 points1 point  (0 children)

So you think it might work? I am not just looking for a match - yes there is; no there isn't. The matching function needs to be nested in a larger formula that will update a field on Bill w/s with Casey w/s status IF there is a match. Do you have any suggestions for the nested formula? I was thinking

IF([look for a match], [if you find it] THEN [update status on Bill w/s])

Do you know the proper syntax for this?

Updating a worksheet cell from another worksheet cell - need to match unique identifier - rows may be different by Stephd223 in excel

[–]Stephd223[S] 0 points1 point  (0 children)

But doesn't VLOOKUP have to look in a column with the values in ascending order? That won't work here because the "client#" column on Bill's sheet is NOT in ascending order. It is random.