_
        

    


    
    


        
        

        

            
            

                
                


                

                    
                    

                        A1
                        — Hero_Sheet
                    


                    

                        
                        

                            

                                Your Spreadsheet

                                Problems, Solved

                                in Plain English.
                            


                            

                                I'm an AI chat assistant who lives and breathes spreadsheets. Describe what you're stuck on — a broken formula, messy data, a VBA macro that won't cooperate — and I'll walk you through the fix, step by step.
                            


                            

                                // Works with Excel & Google Sheets. Just tell me which one.
                            


                            

                                
                                    🧙 Ask Your First Question
                                
                                
                                    See how it works ↓
                                
                            

                        


                        
                        

                            

                                
                                

                                    Chat
                                    Sheet1
                                    +
                                


                                
                                

                                    
                                    

                                        

                                            
I have a column of names like "Smith, John" and I need to flip them to "John Smith". I'm in Google Sheets.

                                        

                                    


                                    
                                    

                                        

                                            
🧙 Spreadsheet Wizard

                                            
Nice one. Here's the formula — assuming your name is in A2:

                                            

                                                =TRIM(MID(A2,FIND(",",A2)+2,100))&" "&LEFT(A2,FIND(",",A2)-1)
                                            

                                            
How it works: FIND locates the comma. MID grabs everything after it (the first name). LEFT grabs everything before it (the last name). TRIM cleans up extra spaces.

                                        

                                    


                                    
                                    

                                        

                                            
What if some cells don't have a comma?

                                        

                                    


                                    
                                    

                                        

                                            
🧙 Spreadsheet Wizard

                                            
Smart edge case! Wrap it in an IF check:

                                            

                                                =IF(ISERROR(FIND(",",A2)), A2, ...formula above...)
                                            

                                            
If there's no comma, it just returns the name as-is. No errors. ✓

                                        

                                    

                                


                                
                                

                                    

                                        Try:
                                        "How do I VLOOKUP across sheets?"
                                        "Write me a VBA macro to..."
                                        "Explain SUMIFS vs SUMPRODUCT"
                                    

                                

                            

                        

                    

                

            


            
            

                

                    

                        B1:F1
                        — Example_Queries
                    


                    

                        Things You Can Actually Ask Me
                    

                    

                        // I'm an AI — I can't open your files or connect to your spreadsheet. But paste your formula, an error message, or a sample of your data as text, and I'll figure it out.
                    


                    
                    

                        
                        

                            

                                
                                Formulas
                                Row 1
                            

                            

                                
"My XLOOKUP returns #N/A even though I can see the value in the lookup range. What's going wrong?"

                                
→ I'll check for trailing spaces, data type mismatches, exact vs. approximate match, and other common traps.

                            

                        


                        
                        

                            

                                
                                Macros & Scripts
                                Row 2
                            

                            

                                
"I need a VBA macro that loops through all sheets in my workbook and copies row 1 to a summary sheet."

                                
→ I'll write the macro, comment every line, and explain how to paste it into the VBA editor.

                            

                        


                        
                        

                            

                                
                                Data Cleaning
                                Row 3
                            

                            

                                
"I imported 10,000 rows and the dates are a mix of MM/DD/YYYY and DD-Mon-YY. How do I standardize them?"

                                
→ I'll give you formulas or a script to parse both formats and convert to your preferred standard.

                            

                        


                        
                        

                            

                                
                                Pivot Tables
                                Row 4
                            

                            

                                
"I want a pivot table that shows monthly revenue by product category, with a running total column. Walk me through it?"

                                
→ I'll describe exactly which fields go where and how to add calculated fields for running totals.

                            

                        


                        
                        

                            

                                
                                Learn & Compare
                                Row 5
                            

                            

                                
"What's the difference between INDEX-MATCH and VLOOKUP? When should I use each?"

                                
→ I'll explain the tradeoffs clearly, with examples in both Excel and Sheets syntax.

                            

                        

                    

                

            


            
            

                

                    

                        C1:C3
                        — How_To_Use
                    


                    

                        Three Steps. No Setup.
                    


                    

                        
                        

                            

                                

                                    =ROW(1)
                                

                                
01

                                
Describe Your Problem

                                

                                    Type what you're trying to do. Paste the formula that's broken. Mention whether you're in Excel or Google Sheets. Paste the exact error text if there is one.
                                

                                

                                    > "My SUMIFS keeps returning 0..."
                                

                            

                        


                        
                        

                            

                                

                                    =ROW(2)
                                

                                
02

                                
Get the Solution + Explanation

                                

                                    I'll write the formula, macro, or step-by-step instructions. I'll explain why it works so you don't need to ask again next time. I'll flag differences between Excel and Sheets.
                                

                                

                                    > "Here's the fix — your criteria range was one row short..."
                                

                            

                        


                        
                        

                            

                                

                                    =ROW(3)
                                

                                
03

                                
Follow Up & Iterate

                                

                                    Something not quite right? Tell me. I'll adjust the formula, try a different approach, or break it down further. It's a conversation, not a one-shot answer.
                                

                                

                                    > "Almost! But I also need it to ignore blank rows..."
                                

                            

                        

                    

                

            


            
            

                

                    

                        D1:D4
                        — Demo_Examples
                    


                    

                        What Chatting With the Wizard Looks Like
                    

                    

                        // Demo examples — fictional sample exchanges that show the format, not real user quotes.
                    


                    

                        

                            

                                ex
                                Demo — Formula Rescue
                            

                            
You paste a nested IF that keeps returning the wrong result. The Wizard spots the misplaced parenthesis and suggests switching to IFS — explaining what changed and why it works.

                        


                        

                            

                                ex
                                Demo — Macro Walkthrough
                            

                            
You ask for a VBA macro. You get the code with every line commented, so `For Each ws In Worksheets` actually makes sense before you run it — plus how to test it safely on a copy of your file.

                        


                        

                            

                                ex
                                Demo — Function Deep-Dive
                            

                            
You ask about Google Sheets QUERY syntax. You get an example formula plus a note on where it differs from SQL — no forum scrolling required.

                        

                    

                

            


            
            

                

                    

                        E1:E5
                        — FAQ_Sheet
                    


                    

                        Frequently Asked Questions
                    


                    

                        
                        

                            
                            
                        


                        
                        

                            
                            
                        


                        
                        

                            
                            
                        


                        
                        

                            
                            
                        


                        
                        

                            
                            
                        

                    

                

            


            
            

                

                

                    

                        

                            Z1
                            — Final_Cell
                        


                        

                            Stop Googling Formulas.

                            Ask the Wizard.
                        


                        

                            Whether it's a broken VLOOKUP at 2am or a macro you can't quite get right,
                            type your question and get a real answer — with an explanation, not just a formula to blindly paste.
                        


                        

                            I'm an AI, not a certified accountant — test formulas and macros on a backup copy first, and double-check anything that drives critical financial decisions.
                        


                        
                        

                            

                                fx
                                =
                                
                                
                            

                        


                        
                            🧙 Meet the Spreadsheet Wizard
                        

                        
Chat-based AI on AURVEK. No installs, no extensions. No payment to open — usage consumes your wallet balance.

                    

                

            

        


        
        

    


    

Related assistants